Home » SQL & PL/SQL » SQL & PL/SQL » how can return value from column value more 3267k (windows xp database 10g)
how can return value from column value more 3267k [message #393411] Sun, 22 March 2009 12:50 Go to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
DECLARE
v_file_loc long raw;
v_diagram_size INTEGER;
BEGIN
select image
into v_file_loc from emp where empno=7499;
v_diagram_size := utl_raw.LENGTH(v_file_loc);
DBMS_OUTPUT.PUT_LINE('Diagram size: ' || v_diagram_size);
end;
/
Re: how can return value from column value more 3267k [message #393412 is a reply to message #393411] Sun, 22 March 2009 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use an external program or use url_raw.substr and get it chunk per chunk.
And urgently migrate to blob.

Regards
Michel
Re: how can return value from column value more 3267k [message #393414 is a reply to message #393412] Sun, 22 March 2009 13:02 Go to previous messageGo to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
thanks you but can explain this through example how use url_raw.substr in my example

thanks
regard
Re: how can return value from column value more 3267k [message #393418 is a reply to message #393411] Sun, 22 March 2009 13:14 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_raw.htm#BABIFIJB

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/


You should NOT be using LONG datatype & using BLOB instead!

[Updated on: Sun, 22 March 2009 13:15]

Report message to a moderator

Re:blbo data type [message #393434 is a reply to message #393418] Sun, 22 March 2009 15:55 Go to previous messageGo to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
with data type can insert image more 2(GB) and if not how much size can insert into column image from blob
Re: how can return value from column value more 3267k [message #393435 is a reply to message #393411] Sun, 22 March 2009 17:02 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>with data type can insert image more 2(GB) and if not how much size can insert into column image from blob

Hmmmm, an OCP who is incapable or unwilling to Read The Fine Manual found at http://tahiti.oracle.com must only be a good test taker.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref19
=========================================================
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#i45885

from URL above the Fine Manual states

"LONG Datatype

LONG columns store variable-length character strings containing up to 2 gigabytes -1, or 231-1 bytes. LONG columns have many of the characteristics of VARCHAR2 columns.
You can use LONG columns to store long text strings.
The length of LONG values may be limited by the memory available on your computer. LONG literals are formed as described for "Text Literals".

Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB, BLOB) instead.
LONG columns are supported only for backward compatibility."

[Updated on: Sun, 22 March 2009 17:16]

Report message to a moderator

Previous Topic: Errors on homework, need help
Next Topic: need help writing a query
Goto Forum:
  


Current Time: Sat Dec 03 03:59:46 CST 2016

Total time taken to generate the page: 0.04828 seconds