Home » Developer & Programmer » Precompilers, OCI & OCCI » With statement over oci (Oracle 9.2.0.6.0)
With statement over oci [message #336885] Tue, 29 July 2008 05:13 Go to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi@all,
i tried to get an querie over oci with the following statement
with name as (subquerie) select * from name


oci is not recognizing that this is an select statement. here my question. is it possible to fire such statements over oci?

thanks in advance.

regards
eigeneachse

Report message to a moderator

Re: With statement over oci [message #336897 is a reply to message #336885] Tue, 29 July 2008 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Which version of OCI?
What is the error? Maybe it is just your code that is wrong.

Regards
Michel

Report message to a moderator

Re: With statement over oci [message #336901 is a reply to message #336897] Tue, 29 July 2008 05:32 Go to previous message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi Michel,
thanks for your reply. It was indeed an statement error.
It works fine over oci.

Sorry for this non useful post.

regards

eigeneachse

Report message to a moderator

Previous Topic: access violation on OCIStmtExecute
Next Topic: compiling C++ code with Pro*C
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 11:56:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.