OraFAQ Forum: Forms » Using Select Into statment in Forms 6i

Home » Developer & Programmer » Forms » Using Select Into statment in Forms 6i (forms 6i)

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

Using Select Into statment in Forms 6i [message #315517]

Mon, 21 April 2008 16:40

deahayes3
Messages: 203
Registered: May 2006

Senior Member

Can anyone tell me why I cant use Select Into statement in a datablock trigger in Forms 6i, I am getting an error, its telling me the table name needs to be declared

select emp_full_name, user_person_type
into y , z
from EMPL_MASTER_V
where employee_number = :EMPL_MASTER_V.employee_number;

Report message to a moderator

Re: Using Select Into statment in Forms 6i [message #315775 is a reply to message #315517]

Tue, 22 April 2008 14:29

deahayes3
Messages: 203
Registered: May 2006

Senior Member

All I had to do was add the schema name

APPS.EMPL_MASTER_V instead of just the table name empl_master_v

Report message to a moderator

Re: Using Select Into statment in Forms 6i [message #315781 is a reply to message #315775]

Tue, 22 April 2008 14:59

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Does it mean that 'empl_master_v' table doesn't belong to your schema (but 'apps'), and that you didn't create a synonym to it?

Because, I don't see any other valid reason for such an error (although, I prefer Oracle error code and message instead your own words) as specifying tables' owner is NOT obligatory.

Report message to a moderator

Re: Using Select Into statment in Forms 6i [message #315787 is a reply to message #315781]

Tue, 22 April 2008 15:30

deahayes3
Messages: 203
Registered: May 2006

Senior Member

Yes, it belonged to schema "apps", and no synonym on either schema

Report message to a moderator

Re: Using Select Into statment in Forms 6i [message #315798 is a reply to message #315787]

Tue, 22 April 2008 16:07

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"Either schema"? Well, you can't create a synonym named as a table because Oracle wouldn't allow you to do that (in the same schema, of course):

SQL> create synonym dept for dept;
create synonym dept for dept
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object


SQL>

Report message to a moderator

Previous Topic:	ITS URGENT NEXT MATCH WORD
Next Topic:	about olb

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 12:23:53 CDT 2024