OraFAQ Forum: SQL & PL/SQL » ERROR WHILE MANIPULATING A PL/SQL TABLE.

Home » SQL & PL/SQL » SQL & PL/SQL » ERROR WHILE MANIPULATING A PL/SQL TABLE.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ERROR WHILE MANIPULATING A PL/SQL TABLE. [message #117]

Tue, 15 January 2002 04:43

Ayyappan pillai Sujith Ku
Messages: 6
Registered: November 2001

Junior Member

Hi Friends,

I am facing a problem while manipulating a PL/SQL table called "empNames". The PL/SQL table is returned from a function. But if i try to manipulate it with empname.count, it returns an error :
"ORA-01041 internal error. host def extension doesnot exist".

If once this error comes, then i need to reconnect to oracle to get even empname's single data (ie empname(1)). How can i manipulate this PL/SQL table.

One more thing, could i retun and manipulate oracle's PL/SQL table from VB front end. Please help me.

Sujith Kumar

Report message to a moderator

Re: ERROR WHILE MANIPULATING A PL/SQL TABLE. [message #118 is a reply to message #117]

Tue, 15 January 2002 04:59

Vishnu Bhavaraju
Messages: 6
Registered: January 2002

Junior Member

The Plsql table type definition should be accessible to both the calling and called functions/procedures . put that table type declaration in a package header.

Report message to a moderator

Re: ERROR WHILE MANIPULATING A PL/SQL TABLE. [message #137 is a reply to message #117]

Thu, 17 January 2002 03:39

Ayyappan pillai Sujith Ku
Messages: 6
Registered: November 2001

Junior Member

Mr Vishnu,

I already put table type declaration inthe package header. Otherwise it cannot be done.
What may be the actual reason. And i want to know, can plsql/table be manipulate from front end.

Sujith

Report message to a moderator

Previous Topic:	FOREINKEY CONSTRAINT'S REFERENCE TABLE INFORMATION
Next Topic:	Problem about create table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 08 19:36:51 CDT 2023