another thing I used to know 2004-08-26 - By David Sharples
Change your double quotes to single quotes, this works for us here
e.g.
EXEC fs_install.create_temp_ts( '${TEMP_TS} ',${TEMP_NUM_FILES},
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of
Paula_Stankus@(protected)
Sent: 26 August 2004 15:43
To: oracle-l@(protected)
Subject: RE: another thing I used to know
In a ksh script I am trying to declare and pass a variable. I thought =
=3D
the syntax was ${variable name} but it is blowing up:
WRAPPER_RTN=3D3D pkg_bc32_wrapper.prc_wrapper( "${MDL_CDE} ",
-- mdl_cde
*
ERROR at line 5:
ORA-06550 (See ORA-06550.ora-code.com): line 5, column 34:
PLS-00201: identifier '${MDL_CDE} ' must be declared
how do I pass this as a variable from ksh to SQL?
Thanks,
Paula
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
