Issue in oracle query execution

Question

    Below is the module in sybase.


   sub execute_query{
    $connect = "isql  -S $SERVER-U $USER -P $PASS -D $DBNAME";
    $pid = open2(\*Rder, \*Wrter, "$connect");
    Writer->autoflush();
    print Write qq!         
    set transaction isolation level 0
    go
    Select * from remtrench
    go
    !;
    Wrter->close();
    while(<Rder>)
     {
      Parse data
      }

The above code made changes to support oracle below. I was able to connect to oracle.But selecting database query and other query ther than connection doesnt work.Please guide me

    sub execute_query{
    $connect = "sqlplus  $USER/PASS@SERVER
    $pid = open2(\*Rder, \*Wrter, "$connect");
    Writer->autoflush();
    alter session set current_schema = $DBNAME;
    Select * from remtrench;
    Writer->close();
     ....
     }

The above change of mine does not work for alter session the other query (select).Googled on how to execute multiple queries.But still this doesnt help me. Thanks.

sorry, I can't make head or tail of what you're trying to ask. Perhaps you could tell us what error message you're getting? "Does not work" is not helpful. — Jeffrey Kemp
– Jeffrey Kemp, Commented Apr 12, 2011 at 13:06

Dave Cross · Accepted Answer · 2011-04-12 13:10:34Z

2

Is it the missing closing quotation mark on the second line?

Alternatively, why are you interacting with databases using their command line programs? You should be using something like DBI or DBIx::Class.

answered Apr 12, 2011 at 13:10

Dave Cross

69.5k3 gold badges55 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user682571 Over a year ago

No..Anyways using DBI is a better suggestion..Thanks

Randy · Accepted Answer · 2011-04-12 14:53:46Z

0

the ALTER SESSION will be valid within that session, but not if you open more sessions for each sql command.

You may simply prefix the database objects in your queries to get around this requirement such as by referencing tables like this:

SELECT * FROM USER.TABLE

answered Apr 12, 2011 at 14:53

Randy

16.7k2 gold badges40 silver badges56 bronze badges

Collectives™ on Stack Overflow

Issue in oracle query execution

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related