Home » Developer & Programmer » Forms » Calling PL/SQL Table in a package from a remote DB from form (Forms [32 Bit] Version 6.0.8.11.3 (Production))
Calling PL/SQL Table in a package from a remote DB from form [message #415703] Tue, 28 July 2009 18:44 Go to next message
bibsdash
Messages: 47
Registered: April 2008
Member
HI

I am trying to call a PL/SQL Object from a package in a remote DB from a oracle form.
The form version is Forms [32 Bit] Version 6.0.8.11.3 (Production).

TYPE AccessList IS TABLE OF SCOTT.EMP_PUB.EMP_REC@DBLINK


The calling form is throwing the error 'Identifier must be declared'.


Thanks in advance.
Re: Calling PL/SQL Table in a package from a remote DB from form [message #415711 is a reply to message #415703] Tue, 28 July 2009 20:46 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I don't think the SQL*Plus in Forms 6i can handle the construct 'type'.

David
Previous Topic: how to keep a value in the forms for 1 week
Next Topic: Excel Import
Goto Forum:
  


Current Time: Fri Dec 09 11:41:33 CST 2016

Total time taken to generate the page: 0.20472 seconds