Is it possible to pass a paramter to ".sql" from Concurrent program in "SQL*Plus" mode
I have a concurrent program which was setup in "
SQL*Plus
" mode with a "
.sql
" file attached to it.
As per our new requirement, we are supposed to pass one more parameter to our stored procedure. We want to have only " .sql " file and setup multiple concurrent schedules by passing paramter while setting schedule.
Is it possible to pass the parameter from concurrent program, instead of changing the code in " .sql " file?
Early response would enable me solve the problem and really appreciate your help.
Regards,
Sridhar
As per our new requirement, we are supposed to pass one more parameter to our stored procedure. We want to have only " .sql " file and setup multiple concurrent schedules by passing paramter while setting schedule.
Is it possible to pass the parameter from concurrent program, instead of changing the code in " .sql " file?
Early response would enable me solve the problem and really appreciate your help.
Regards,
Sridhar
Tagged:
0