Posted by 'Tim Lindsey' on June 27, 2001 at 12:30:00 EST:
We are using Oracle 8.1.7 and I would like to pass a variable to a PL/SQL procedure and have that variable used in a cursor. The cursor is extracting from a partitioned dataset.
CREATE OR REPLACE PROCEDURE PR_TEST (vPartitionName in VARCHAR2)
IS
CURSOR c_SmallTable
IS
SELECT model,
pn_id
FROM BAMB.TA_TABLE1 partition (vPartitionName);
When I run this in my procedure it doesn't replace vPartition name with MODEL_757 that I pass in when I execute the procedure. What am I doing wrong?
I have Steven Feuerstein's "Oacle PL/SQL" book and in the section on cursor variables he seems to be doing the same thing except the variable is being used as a selected field or on the right of the equal sign on the WHERE clause. Why won't it work for a partition name?