Returning a BLOB to Ksh - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Returning a BLOB to Ksh

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Blob Wars : Blob and Conquer 0.94 (Default branch)	iBot	Software Releases - RSS News	0	06-05-2008 11:00 PM
Blob Wars : Blob and Conquer 0.93 (Default branch)	iBot	Software Releases - RSS News	0	05-10-2008 06:40 PM
Blob Wars : Blob and Conquer 0.92 (Default branch)	iBot	Software Releases - RSS News	0	04-26-2008 04:20 PM
script for reading BLOB data	shriashishpatil	Shell Programming and Scripting	0	04-25-2007 07:11 PM
returning value from sqlplus	malaymaru	Shell Programming and Scripting	1	01-31-2006 04:03 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

05-11-2007

jack1981

Registered User

Join Date: Jul 2006

Posts: 42

Returning a BLOB to Ksh

Hello,

I am currently using a small script to test out part of a larger script I will use llater on. I am querying Oracle 10.1 to return a column which holds a blob value. This value needs unzipped, sent to a file or piped and then amended and re-inserted to another table with the news values. When I run the small test script below I get this error:

Code:

SP2-0678: Column or attribute type can not be displayed by SQL*Plus

Obviously it dosent dump a BLOB to stdout but thats my question I guess, how do I get the data from within the BLOB and unzip it to a file or pipe in SOLARIS?

Here is the small script I am using as a test

Code:

#!/usr/bin/ksh

function get_messages 
{
	   print " select msg_val from mqseries_store where msg_id = 3;
         " | user/pass@d > temp.txt
}

get_messages
wait
cat temp.txt

Bookmarks

« Not working | Combine a datafile with Master datafile, emergent! »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 10:04 AM.