OraFAQ Forum: Precompilers, OCI & OCCI » Declare Table ....Semantics

Home » Developer & Programmer » Precompilers, OCI & OCCI » Declare Table ....Semantics

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

Declare Table ....Semantics [message #338001]

Sat, 02 August 2008 03:19

santosh.chalikwar
Messages: 6
Registered: July 2008

Junior Member

Hi All,
I am trying to connect with a remote data base using PRO*C.
If I use
proc filename.pc in make file..I am getting no error and code is working fine.

but If I use
proc sqlcheck=semantics userid=abc/lmn@xyz filename.pc
I am getting undefined identifier remoteschema.remotetable name.
user id mentioned in my make file describes my local data base.

At first glance I thought I have to declare this table in my .pc
file.
so I use EXEC DECLARE tablename TABLE
(col name type null,
*******
);
But still I am getting the same error.
Please Help Me.

Report message to a moderator

Re: Declare Table ....Semantics [message #338004 is a reply to message #338001]

Sat, 02 August 2008 03:47

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

With "sqlcheck=semantics" Pro*C compiler checks all objects with the connection string you gave.
Connect with SQL*Plus with the same connection string and check if you can see " remoteschema.remotetable".

Regards
Michel

Report message to a moderator

Re: Declare Table ....Semantics [message #338005 is a reply to message #338004]

Sat, 02 August 2008 03:55

santosh.chalikwar
Messages: 6
Registered: July 2008

Junior Member

Thanks for your reply,
But I would like to know whether there is any other way ....
Coz I dont want to change my make file(not passible for some reasons) ..but I can change my .pc file.

One more thing I am using declare table statement but actually it is a synonym (view) created on a remote database table.
So Do I need to change my EXEC SQL DECLARE TABLE statement?

Report message to a moderator

Re: Declare Table ....Semantics [message #338024 is a reply to message #338005]

Sat, 02 August 2008 09:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The name in the "DECLARE TABLE" must the same than in the code.
Without it I can't say more.

Regards
Michel

Report message to a moderator

Previous Topic:	compiling C++ code with Pro*C
Next Topic:	cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 17:33:59 CDT 2025