Oracle Cursor passing multiple value. ORA-01722
Hi,
I am trying to pass multiple parameter using CURSOR, but return the error "ERROR at line 1: ORA-01722: invalid number ORA-06512: at line 18"
My requirement is to delete data from all tables by taking input from user (SPSN and version number). I am stuck in only where multiple rows deletion. for single from every table has been tested successfully.
Please help me on this issue.
This SQL file received two parameter from Shell script.
1. SPSN = 'ECC'
2. VERSION NUMBER='3.1.2.0'
for example: v_spsn := '&1'; v_version := '&2';
---------------------------SQL script-----------------------------
set head off;
set feedback off;
set serveroutput on;
I am trying to pass multiple parameter using CURSOR, but return the error "ERROR at line 1: ORA-01722: invalid number ORA-06512: at line 18"
My requirement is to delete data from all tables by taking input from user (SPSN and version number). I am stuck in only where multiple rows deletion. for single from every table has been tested successfully.
Please help me on this issue.
This SQL file received two parameter from Shell script.
1. SPSN = 'ECC'
2. VERSION NUMBER='3.1.2.0'
for example: v_spsn := '&1'; v_version := '&2';
---------------------------SQL script-----------------------------
set head off;
set feedback off;
set serveroutput on;
0