Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling oracle stored procedures from command line (NOT from application)

568605Mar 22 2007 — edited Mar 22 2007
Hello everyone, I'm a little new to oracle, I've been working with SQL Server for a while now. I need to call a stored procedure from command line, not from some front end application (everything online talks about how to call oracle stored procs from C#, vb.net code...i don't need any of that). In SQL Server you would say EXEC stored_proc param1, param2....

How do you do that in oracle? Also, the stored procs I have take a cursor as an out parameter. This doesn't exist in Sql Server so I'm unfamiliar with it. My oracle stored proc has two parameters: an IN VARCHAR2, and an OUT PKG_REFCURSOR.t_cursor.

How do I call this from command line?
Something like this:

SQL> EXEC stored_proc 'aaa', New Cursor

Please help me someone and again don't tell me how to call a stored proc from C# or something I don't need that.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2007
Added on Mar 22 2007
1 comment
527 views