Home » SQL & PL/SQL » SQL & PL/SQL » ERROR WHILE MANIPULATING A PL/SQL TABLE.
ERROR WHILE MANIPULATING A PL/SQL TABLE. [message #117] Tue, 15 January 2002 04:43 Go to next message
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
Re: ERROR WHILE MANIPULATING A PL/SQL TABLE. [message #118 is a reply to message #117] Tue, 15 January 2002 04:59 Go to previous messageGo to next message
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.
Re: ERROR WHILE MANIPULATING A PL/SQL TABLE. [message #137 is a reply to message #117] Thu, 17 January 2002 03:39 Go to previous message
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
Previous Topic: FOREINKEY CONSTRAINT'S REFERENCE TABLE INFORMATION
Next Topic: Problem about create table
Goto Forum:
  


Current Time: Thu Mar 28 03:57:55 CDT 2024