Dear All,

          Iam a newbiw to PL/SQL. So iam having a query regarding accessing PL/SQL through C program.

I have written code for connecting to a database and select one row and just print it out.. Iam able to make a connection with the databse. But after connection it is showing that select query failed.... but if iam directly selecting through PL/SQL prompt iam able to do the same..

what may be the problem..
pls help..

thanks
krishnaprasd

[Please don't post in HTML.]

On Sat, Feb 25, 2006 at 10:52:56AM +0530, Krishnaprasad wrote:
> Iam a newbiw to PL/SQL. So iam having a query regarding
> accessing PL/SQL through C program.

By "PL/SQL" do you mean PostgreSQL? PL/SQL is Oracle's procedural
language; presumably that's not what you're talking about. PostgreSQL
has a procedural language named PL/pgSQL but the rest of your message
doesn't mention anything about server-side functions, so one might
guess that you're using "PL/SQL" to refer to PostgreSQL in general.

> I have written code for connecting to a database and select one row
> and just print it out.. Iam able to make a connection with the
> databse. But after connection it is showing that select query
> failed.... but if iam directly selecting through PL/SQL prompt iam
> able to do the same..

What are the query and the error message? Could you post a simple
but complete program that shows what you're doing? Without more
information it's impossible to know what's wrong.

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match