Home » SQL & PL/SQL » SQL & PL/SQL » passing control to sql script (oracle version 8.5.3)
passing control to sql script [message #363076] Fri, 05 December 2008 00:56 Go to next message
shaksing
Messages: 115
Registered: November 2008
Senior Member
How i can pass control from a stored procedure to a sql script or procedure.Please give your inputs .
Re: passing control to sql script [message #363077 is a reply to message #363076] Fri, 05 December 2008 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is "passing control"?
Explain what is your needs and what you are trying to achieve maybe we can help.

In addition, version 8.5.3 never existed.

Regards
Michel

[Updated on: Fri, 05 December 2008 00:59]

Report message to a moderator

Re: passing control to sql script [message #363081 is a reply to message #363076] Fri, 05 December 2008 01:04 Go to previous messageGo to next message
shaksing
Messages: 115
Registered: November 2008
Senior Member
As the stored procedure finishes it work , it should pass the control to sql script.

Actually i am calling a stored procedure into a script , and i want as soon as the stored procedure finishes its work it should come out of that and carry on with sql script for further process.
Re: passing control to sql script [message #363083 is a reply to message #363076] Fri, 05 December 2008 01:07 Go to previous messageGo to next message
shaksing
Messages: 115
Registered: November 2008
Senior Member
Hi Michel,

Here is the detail..

Minimum Version: Oracle Xellerate Identity Provisioning (8.5.3) is a technology being offered as part of the Oracle 10g Application Server.
Re: passing control to sql script [message #363103 is a reply to message #363083] Fri, 05 December 2008 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't your product but in SQL*Plus when a call to a procedure ends it executes the next statement in the script.

SQL> host type P:\Documents\Temp\SQL\t.sql
select sysdate from dual;
call dbms_lock.sleep(5);
select sysdate from dual;

SQL> @P:\Documents\Temp\SQL\t.sql
SYSDATE
-------------------
05/12/2008 09:15:43

1 row selected.


Call completed.

SYSDATE
-------------------
05/12/2008 09:15:48

1 row selected.

Regards
Michel
Re: passing control to sql script [message #363113 is a reply to message #363076] Fri, 05 December 2008 02:36 Go to previous messageGo to next message
shaksing
Messages: 115
Registered: November 2008
Senior Member
Ok Michel thats what i was looking for . I was just not sure that you just explained.

Can we check that the procedure ran successfully if it called from the sqlscript (as i mentioned earlier), Does a stored procedure returns anything in case it is succesful.
Re: passing control to sql script [message #363117 is a reply to message #363113] Fri, 05 December 2008 02:40 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
when you are able to create stored procedure with return value then you can assign the same value to your required variable.
Re: passing control to sql script [message #363118 is a reply to message #363113] Fri, 05 December 2008 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It depends on your procedure.
If it is a system procedure there is an exception when it fails.
If it is a custom procedure it depends on how you code it.

Regards
Michel
Re: passing control to sql script [message #363136 is a reply to message #363076] Fri, 05 December 2008 03:18 Go to previous message
shaksing
Messages: 115
Registered: November 2008
Senior Member
Thanks Michel and s.raghunathan .
Previous Topic: what is the error here?
Next Topic: Count as array
Goto Forum:
  


Current Time: Fri Feb 14 16:40:36 CST 2025