Home » Infrastructure » Unix » ACCESS tables from Unix script
ACCESS tables from Unix script [message #536438] Wed, 21 December 2011 00:43 Go to next message
vinodprakash
Messages: 2
Registered: September 2011
Location: India
Junior Member
I have a unix script will enables a pl/sql procedure to retrieve data from the DB tables.
I can retrieve data for only 1 row.
My problem is , if there are multiple row to be retrieve then my script fails to get all mutliple rows..
I am using a count procedure to know how many rows are there and then i am jsting retrieveing the values,
I can retrieve only the first row..
please help me out..

Report message to a moderator

Re: ACCESS tables from Unix script [message #536446 is a reply to message #536438] Wed, 21 December 2011 01:01 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is difficult to debug code you can't see, so - could you post code you used? If it is a complex one, make it simple (for example, base it on sample Scott's schema).

Report message to a moderator

Re: ACCESS tables from Unix script [message #536606 is a reply to message #536438] Wed, 21 December 2011 15:58 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member

Write result set to flat file.

[Updated on: Thu, 22 December 2011 00:25] by Moderator

Report message to a moderator

Previous Topic: solaris 10 release - 11gr2
Next Topic: Number of CPU
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 29 10:47:49 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.