| ORA-01008: not all variables bound [message #78] |
Fri, 11 January 2002 02:24  |
Fred
Messages: 34
Registered: August 1999
|
Member |
|
|
Hi;
I´m trying to execute a procedure, but I keep getting this error msg: ORA-01008: not all variables bound.
I checked but I see all variables well declared; what can I be missing?
Thx,
F.-
|
|
|
|
|
|
|
|
| Re: ORA-01008: not all variables bound [message #1070 is a reply to message #78] |
Wed, 27 March 2002 02:33  |
Barathi
Messages: 2
Registered: November 2001
|
Junior Member |
|
|
I am coming across the error 'ORA-01008' while eecuting the below Query. The variable used here is "p_indate" and GLDB is the DB Link name.
INSERT INTO ref_cur_rates@GLDB
(curr_date,
source_currency,
destination_currency,
rates,
units,
status,
last_update_date)
SELECT curr_date,
source_currency,
destination_currency,
(1/POWER(10,units)) * conversion_rate,
units,
1,
p_indate
FROM L_REF_CURR_CONV_DTL
WHERE record_to_date = p_indate;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
