Current Position:Home > Dynamic pages submitting data to stored procedure

Dynamic pages submitting data to stored procedure

Update:11-30Source: network consolidation
Advertisement
Hi,
I am developing an Oracle Portal application and I am facing a problem, if anyone could help me I'd be very grateful.
I have the latest version of Portal 3.0.9, installed on a linux server. I'm using I.E. 6.0 to interface with Portal.
I have a dynamic page that have a <form> tag, like this:
<form name="MyFormName" action="MySchema.MyStoredProcedure" method="post">
I changed the form name and the stored procedure name, because I'm in Brazil and these names are in portuguese, it won't make much sense in english...
Well, problem is, when I click on submit button, instead of calling the stored procedure, the browser tries to load a page called "http://MyServer/pls/MyDAD/MySchema.MyStoredProcedure" instead of calling the actual stored procedure. The procedure have all the parameters defined on <input> tags within the html code of the dynamic page.
I don't know what else I can do, any help or hint would be greatly appreciated. Sorry for my bad english.
Thanks In Advance,
Tiago Rocha

The Best Answer

Advertisement
Have you specified any value (greater than 0) in the Portlet expires in ... minutes field ?
If you have, then I guess your dynamic page is getting cached.
Before submitting the form, do a right click on the browser page and view the page source.
What does the <form> tag look like ?
Does it still show the old procedure name ?
  • Dynamic pages submitting data to stored procedure Update:11-30

    Hi, I am developing an Oracle Portal application and I am facing a problem, if anyone could help me I'd be very grateful. I have the latest version of Portal 3.0.9, installed on a linux server. I'm using I.E. 6.0 to interface with Portal. I have a dy

  • Set page item from a stored procedure Update:10-11

    Dear reader We would like to have a stored procedure to run every 10 minutes. When the procedure starts, the user has to be warned that the update process is running. When the procedure is finished, the user should receive a message that the update p

  • Hi to all... What is a  XML data provider,stored Procedure, personal data Update:11-30

    Hi to all... What is a  XML data provider,stored Procedure, personal data providers in deski.  when we use these data provider in desk top intelligence.. and use of it. Please give detail description of the above... Thanks for reply..........Hi, We c

  • Inserting data using stored procedure Update:10-11

    Using SQL Server Express 2014, I'm creating a stored procedure to accept parameters and convert data from a staging table to a production table. The parameters specify the table names and a field to lookup in another table. This is the first stored p

  • Export data using stored procedure to excel Update:11-30

    How to export and save data from SQL Server to MS Excel using stored procedure. Thanks in advance AbhinavYou can use multiple options 1. distributed query like OPENROWSET/OPENDATASOURCE http://www.excel-sql-server.com/excel-import-to-sql-server-using

  • Displaying data from stored procedure into textbox fields based on user input. Update:10-11

    I have a stored procedure that is selecting data from a table called "Vendor" in my database.  The data that is being returned are vendor names, vendor addresses, vendor Id's, etc...In my stored proc, I have one parameter that allows the user to

  • Web Service receives no data from Stored Procedure call. Update:10-11

    Issue: When calling a Stored Procedure from a Web Service no data is returned. Lead up: I can call the SP 100 times a day for 3-4 days then for some reason the Web Service no longer get the data from SQL. I have ran a trace and I can see the SP runni

  • Preventing saved web pages submitting data Update:10-11

    Hi, whilst someone was messing around with a simple site I built (literally just a guestbook thing using all the DW behaviours) they found something I hadn't really thought about. They could save the web page with the form on, to their desktop. They

  • How to retrive data through stored procedure in mysql from remote machine? Update:10-11

    Hello everybody, I am having problem in accessing data of mysql through stored procedure. It works fine if I use "jdbc:mysql://localhost:3306/[database name]" instead of "jdbc:mysql://[IP address]:3306/[database name]". The connection

  • OIM: Retrieve data from stored procedure,  pre populate it in Resource form Update:11-30

    Hi, I need to retrieve data form a stored procedure that i have created . This data needs to be per populated in the Iplanet resource from. The stored procedure will have one input string and one output string. Thankz, Sanjay Rulez1. Prepare OIM Admi