Re: Regarding PL/SQL with C

[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