Re: executing a stored procedure through SQL PLUS

>Hello, How do I execute a stored procedure through SQL *PLUS with IN and
OUT
>parameters. Any example would be helpful.

Maybe, something like this:

SQL> VARIABLE var_name NUMBER (or whatever) SQL> EXECUTE package_name.proc_name ('parm1' , :var_name) (var_name is OUT-parm)
SQL> PRINT var_name (to show the value)

Roel Received on Wed Jun 10 1998 - 09:38:58 CDT