Thread: bad bind variables
10-17-03, 10:21 #1Registered User
- Join Date
- Oct 2003
- Missouri, USA
Unanswered: bad bind variables
In Oracle, I have a PL/SQL procedure that is called from a module in Designer 6i. It's a simple one: insertextent(id,:CGU$USER);
Then the insertextent procedure is:
INSERT INTO pig_cells(PIG_ID, CELL_ID_NMBR)
SELECT id, EXTENT_ID
USER_NAME = user_id;
WHEN NO_DATA_FOUND then
The table EXTENT_LIST only has 2 columns (USER_NAME and EXTENT_ID).
My problem is that I'm getting PL/SQL ERROR 49: bad bind variable 'CGU$USER'. I tried replacing the 'CGU$USER' with 'x', but still got the error. Can anyone help me with this bad bind variable? Thanks much, Margaret
10-17-03, 12:17 #2Registered User
- Join Date
- Jul 2003
you need a declare section which you specify what type and how
many variables you are passing into the proc.
I always like to specify my variables with a 'v_' so they are
easy to detect in the proc.
I think this would be better personally.
create or replace procedure insertextent
where user_name = v_user_id;
INSERT INTO pig_cells
you can lead someone to something but they will never learn anything ...