Calling oracle stored procedures from command line (NOT from application)
568605Mar 22 2007 — edited Mar 22 2007Hello 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.