Hi there,
I know that this topic was covered before using odbc plug-in to call a stored procedure but it seems to me so sloppy. So I would like to know if there is any other way to call a oracle procedure in oracle oci plug-in.
I have tried calling the procedure in the after tab in oci plug-in but no success. The datastage gives me the error:
ORA-06576: not a valid function or procedure name
and my code is :
CALL PRC_REFRESH_ALL_MVIEWS;
Thanks mates
HOW TO CALL A ORACLE STORED PROCEDURE
Moderators: chulett, rschirm, roy
Hi,
You simply need the full name shema name and all _ you must have the privilages to read/run it.
It has been a while so if call doesn't work try execute (or similar)
I did it a year ago with before and after sql with OCI stage it works fine.
IHTH,
You simply need the full name shema name and all _ you must have the privilages to read/run it.
It has been a while so if call doesn't work try execute (or similar)
I did it a year ago with before and after sql with OCI stage it works fine.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Just clearing that you need Oracle 9+ for Craig's idea.
IHTH,
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org