Home » SQL & PL/SQL » SQL & PL/SQL » how to get length long raw datatype (merged 4)
how to get length long raw datatype (merged 4) [message #392213] Tue, 17 March 2009 01:16 Go to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
There I have a table with a field of type long raw of this table contains photographs of the staff and approximately 500000 both scored record card is printed with the name of the employee, but sometimes does not come out of that image, I want to get Dbms_lob.getlength the size of the image is not printed if the card is empty Please Is there anyone to compare the ideas of how I work and how to get length

[Updated on: Tue, 17 March 2009 01:35] by Moderator

Report message to a moderator

Re: how to get length long raw datatype [message #392215 is a reply to message #392213] Tue, 17 March 2009 01:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: how to get length long raw datatype (merged) [message #392222 is a reply to message #392213] Tue, 17 March 2009 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fetch it.

Regards
Michel
how to get length long raw datatype [message #392337 is a reply to message #392213] Tue, 17 March 2009 09:22 Go to previous messageGo to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
There I have a table with a field of type long raw of this table contains photographs of the staff and approximately 500000 both scored record card is printed with the name of the employee, but sometimes does not come out of that image, I want to get Dbms_lob.getlength the size of the image is not printed if the card is empty Please Is there anyone to compare the ideas of how I work and how to get length
best regard
hamdan
Re: how to get length long raw datatype [message #392338 is a reply to message #392337] Tue, 17 March 2009 09:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: how to get length long raw datatype [message #392345 is a reply to message #392337] Tue, 17 March 2009 10:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
STOP reposting the same question the answer is the same.
Next posts with the same question will be deleted.

Regards
Michel
Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #392370 is a reply to message #392345] Tue, 17 March 2009 12:27 Go to previous messageGo to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
I implemented this code and I have this error ,so please what happen

declare
n varchar2(80);
cursor m
is
select image ,empno from emp ;
begin
for a_record in m
loop
if a_record.image=null then
update emp set print_fmx='x';
else
update emp set print_fmx='p';
end if;
end loop;
end;
regard
Re: how to get length long raw datatype (merged 4) [message #392371 is a reply to message #392213] Tue, 17 March 2009 12:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
ERROR? Error? I don't see any error.


Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #392376 is a reply to message #392370] Tue, 17 March 2009 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
if a_record.image=null then

This can never happen.
Review test against NULL.

Regards
Michel
Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #392379 is a reply to message #392376] Tue, 17 March 2009 13:08 Go to previous messageGo to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
I have a table with a column long raw image and I want to know whether this column is also null or not Is it possible I know how the length of this column, and I apologize if it caused any inconvenience
Re: how to get length long raw datatype (merged 4) [message #392381 is a reply to message #392213] Tue, 17 March 2009 13:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #392384 is a reply to message #392379] Tue, 17 March 2009 13:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible.

Regards
Michel
Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #392475 is a reply to message #392384] Wed, 18 March 2009 02:41 Go to previous messageGo to next message
hamdan_oracle ocp
Messages: 12
Registered: August 2008
Location: jordan
Junior Member
Annexes in the column Permission_image pictures and also the image of the card should be out Allehauma files were not present in the image database of the card is not come to that I want to work if there is no requirement of the image does not print the card and thank you for your patience
Re: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind [message #392588 is a reply to message #392475] Wed, 18 March 2009 09:39 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Here is an interesting link for you!
Previous Topic: Connect By Query
Next Topic: Question about where-clause in select-statements
Goto Forum:
  


Current Time: Fri Nov 08 00:12:21 CST 2024