How to run a SQL server store procedure from Apex (oracle)?
461036Jun 26 2006 — edited Jun 28 2006Our application needs to call a store procedure in the SQLserver database. The sotre procedure works fine in the SQL server side. However, when I tried to call the store procedure in TOAD as:
exec my_store_procedure(para1, para2);
I kept getting the error message:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'my_store_procedure'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I have searched online but couldn't find the solution. This is an emergency, so prompt reply is Highly Appreciated!
Luc