OraFAQ Forum: Forms » Calling PL/SQL Table in a package from a remote DB from form

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))

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

Calling PL/SQL Table in a package from a remote DB from form [message #415703]

Tue, 28 July 2009 18:44

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.

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't think the SQL*Plus in Forms 6i can handle the construct 'type'.

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 24 10:18:30 CDT 2026