PLSQL Procedures 
Author Message
 PLSQL Procedures

Hi,

I am making a website using Oracle webserver 3 using PLSQL
I am having small a problem using procedures

I have a login page executed with the procedure "login"
Then another procedure called "exec_login" which does the processing for
"login" when the user clicks the submit button.
Then there is a small problem when i execute a procedure from within
another procedure it does not end the current procedure.
Theirfore is the user gets his username / password wrong too many times
the oracle server falls over because there are too many procedures
within procedures open.
Is there any way to tell the oracle server to finish the current
procedure close it and remove it from memory and then go on to a new one
?

A quick outline below

procedure login
-- display web page
-- include text boxes for user to enter login details
-- submit button to dubmit details to "exec_login"
end login;

procedure exec_login (variables from login)
--check the user is valid
if user name and password = ok then
 Next_Procedure
 -- this procedure stays open waiting for Next_Procedure to finish
(which it never will) till the user closes the browser
end if;

if user name and password = not ok then
 go back to login
 -- this procedure stays open waiting for login to finish
end if;

end exec login;



Sun, 11 Mar 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. getting output of Oracle PLSQL/Procedure from Java

2. Dynamically Calling PLSQL Procedures via DBMS_SQL

3. PLSQL procedure gets hung..

4. OWA_UTIL.IDENT_ARR Parameter on PLSQL procedure

5. connect to a remote Oracle db using PLSQL procedure

6. Connect to a remote Oracle db using PLSQL procedure

7. PLSQL procedure return values

8. How can I interpert error codes returned in PLSQL procedure?

9. How to pass return value from a PLSQL procedure or function to a UNIX wrapper?

10. PLSQL-proc calling PLSQL-proc on another machine

11. PLSQL/Oracle Stored Procedures


 
Powered by phpBB® Forum Software