| Using Bulk Binds in Stored Procedures [message #2593] |
Tue, 30 July 2002 03:11  |
Mark Grimshaw
Messages: 73
Registered: June 2002
|
Member |
|
|
Hi,
I am getting error 'PLS-00493 invalid reference to a server-side object or function in a local context' when trying to compile the following s.p:-
PROCEDURE ReturnRecordArray(recArray IN OUT RecordArrayT) IS
BEGIN
SELECT * BULK COLLECT INTO RecArray FROM
TEST_TABLE;
END;
where RecordArrayT is defined as :
TYPE RecordArrayT IS VARRAY(10) OF TEST_TABLE%ROWTYPE;
I have looked at the documentation but don't quite understand where I am going wrong.
TYIA
Mark
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
