Re: OraPerl question

"Robert H. Thompson" wrote:
>
> I have a question about using OraPerl. I have an Oracle 7.3.3 database
> running and would like to use OraPerl to do the following:
>
> find out the current database user. doing something like this:
>
> &ora_do($lda,'show user');
>
> or to manipulate some of the database environment variables like this:
>
> &ora_do($lda,'set pagesize 66');

You are confusing SQL statements with SQL*Plus commands. Both 'show user' and 'set pagesize' are SQL*Plus commands. They are executed by the SQL*Plus. The are not SQL statements, and are not executed by the database server.

Oraperl is not SQL*Plus. It can pass SQL statements to the server. It cannot obey SQL*Plus commands.

As another contributer has told you, you cna find the current user by using the SQL statement 'select user from dual'. I can't imagin what you expect 'set pagesise 66' to do for you. It is a command whihc affects the formatting of the output of SQL*Plus. What the output from Oraperl looks like depends entirely on what perl code you write to produce said output. Received on Thu Feb 25 1999 - 18:02:23 CET