Home » Developer & Programmer » Forms » Using Select Into statment in Forms 6i (forms 6i)
Using Select Into statment in Forms 6i [message #315517] Mon, 21 April 2008 16:40 Go to next message
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;
Re: Using Select Into statment in Forms 6i [message #315775 is a reply to message #315517] Tue, 22 April 2008 14:29 Go to previous messageGo to next message
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
Re: Using Select Into statment in Forms 6i [message #315781 is a reply to message #315775] Tue, 22 April 2008 14:59 Go to previous messageGo to next message
Littlefoot
Messages: 20896
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.
Re: Using Select Into statment in Forms 6i [message #315787 is a reply to message #315781] Tue, 22 April 2008 15:30 Go to previous messageGo to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

Yes, it belonged to schema "apps", and no synonym on either schema
Re: Using Select Into statment in Forms 6i [message #315798 is a reply to message #315787] Tue, 22 April 2008 16:07 Go to previous message
Littlefoot
Messages: 20896
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>
Previous Topic: ITS URGENT NEXT MATCH WORD
Next Topic: about olb
Goto Forum:
  


Current Time: Tue Dec 06 06:15:20 CST 2016

Total time taken to generate the page: 0.11324 seconds