PL/SQL (MOSC)

MOSC Banner

Oracle Cursor passing multiple value. ORA-01722

edited Apr 5, 2012 1:56AM in PL/SQL (MOSC) 29 commentsAnswered ✓
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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center