DSXchange

The stored procedure inserts some rows into the table. It does not return any values. Just plain insert statements. I also forgot to mention that the stored procedure is in BI_APP schema and the stored procedure insert the rows into another schema (let's say BI_APP_TEST). I couldn't create the store...

Yes, it is the same user id and password.

Thanks! I've thought about that initially. When I copy and paste that command in TOAD and run it, it ran successfully......

I am trying to call and execute a stored procedure in After SQL. Oracle_OCI_9i_6: Executing AfterSQL Oracle_OCI_9i_6: CALL BI_APP.MUNS_PROC Oracle_OCI_9i_6: ORA-06576: not a valid function or procedure name BI_APP is the database schema and MUNS_PROC is the name of my stored procedure. I've tried us...