Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Stored procedure output to a tables?
Greetings.
I have a vb.net oledb procedure that can schedules an oracle procedure to run and returns to me an oracle job number.
It looks like this:
FUNCTION CPM_SUBMIT (iprocname in varchar)
return number
is
jobno number;
BEGIN
DBMS_JOB.SUBMIT(jobno,iprocname||';',sysdate); commit; return (jobno);
We need Oracle output, both the extracts and the any execution logs to be accessable to this asp.net front end and the sql server databases that will track processes. In the mix (soon), will be a new NAS access able to both sides.
My Oracle Noobie questions - Your insite is greatly appreciated!!!
Again, thank you for *any* information you might have! Received on Sat Feb 03 2007 - 16:15:55 CST