pl/Sql err ORA-21710: argument is expecting a valid memory address ... 1

[Adityag74]

Hello All,

I am using pl/sql sql nested table type for a function.
This function returns pl/sql nested table type object using cast statements.
LIKE THIS Example.
=============
SELECT ID,Company_ID,Security_ID
FROM TABLE(CAST (XYZ_Pkg.getFullCoverage(6511, 'EA_SAM', 15 JAN 2003') AS GTNT_Inputs))

here GTNT_Inputs IS a nested table type.

I ma using SET AUTONOMOUS TRANSACTION.And indise this function there are lot of similar calls and finally a nested table type object is returned.


Problem is in case of a small set(10 or 50 records) it works fine.But some time In case of big result set of 1500 records i get this error.
==========================
ORA-21710: argument is expecting a valid memory address of an object
===========================
and this is very unpredictable as most of the time it works with big sets aso.But some times it gives above mentioned error.
I am not sure what's wrong.I am using Oracle 8.1.7

Please suggest what's the solution for this error.
Really appreciate ur help.

Regards

Adi...

 

[sem]

I found a bug description on Metalink:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=1325384

Try to apply the latest patchset. Regards, Dima

 

[Rouven]

Hi all,

Looks like I have the same problem. Under Solaris 2.8 with Oracle Version 8.1.7.2 where the Bug: 1325384 mentioned by sem should be solved. Does anyone have any ideas?

Thanks,
Rouven

 

[AOLEURO]

Wrong forum - use Oracle release 8 and 8i forum Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !