Home » SQL & PL/SQL » SQL & PL/SQL » * Running Stored procedure *
* Running Stored procedure * [message #36814] Sun, 23 December 2001 06:54 Go to next message
Robin
Messages: 73
Registered: October 2001
Member
Dear Expert,
How Can I run stored procedure or function of ORACLE from form of DEVELOPER200 ( I know 'execute ' command is used running it from 'SQL>' prompt). Pls write me the command.

Thanks
Robin

----------------------------------------------------------------------
Re: * Running Stored procedure * [message #36816 is a reply to message #36814] Sun, 23 December 2001 07:13 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
you dont need to use exec when you call stored procedures from forms or other pl/sql procedures.

example:
procedure_name(param1,param2,..);

if it is a function

ret_val := function_name(p1,p2..);

----------------------------------------------------------------------
Previous Topic: *** .txt file to Table data transfer ***
Next Topic: ORA 6502 Pl/SQL : numeric or value error
Goto Forum:
  


Current Time: Thu Apr 18 10:50:09 CDT 2024