| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS SQL
A copy of this was sent to mashy_at_null.net
(if that email address didn't require changing)
On Thu, 15 Oct 1998 16:27:38 GMT, you wrote:
>Hiya !
>
>I've got a table which stores the names of the packages and the procedures . I
>want each & every package-procedure to be fired by a procedure on the table
>as a batch process .... Can anybody help me to overcome this problem ...???
>
>For eg :
>
>Table_1
>--------
>PACK_NAME VARCHAR2(50)
>PROC_NAME VARCHAR2(50)
>STATUS VARCHAR2(10)
>
>Data within the table ....
>
>PACK_NAME PROC_NAME STATUS
>=========== ========== =========
>EMP_PACK EMP_BONUS VALID
>EMP_PACK EMP_SIGNOFF INVALID
>
>Here the EMP_PACK.EMP_BONUS will be picked up and fired by the procedure ... I
>tried using the dbms_sql package ... it returns with the ORA-00900 error
>(Invalid SQL Statement) ... as it doesnt understand the Execute 'procedure'
>statement while parsing .... !!
>
>Thanks for ur assistance ...
>
thats cause EXECUTE is just sqlplus and svrmgrl shorthand for:
begin PROC_NAME; end;
try parsing 'begin ' || pack_name || '.' || proc_name || '; end;' instead...
>
>Mashya ..
>
>Pls cc to : mashy_at_null.net
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 15 1998 - 11:52:25 CDT
 |
 |