OraFAQ Forum: Programming Interfaces » Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed

Home » Open Source » Programming Interfaces » Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed [message #643998]

Sat, 24 October 2015 15:25

jdrogers73
Messages: 2
Registered: October 2015

Junior Member

I am running a very basic PHP script on a Redhat Linux box to download photos. I can connect to Oracle with no problem. 114 BLOBS are downloaded before getting ORA-12537 TNS: Connection Closed. Why is it closing? I need to download 2,114 BLOBS.

This is the algorithm:

query = "SELECT picture FROM table WHERE id_number = :id";

foreach(id number)
{
prepare query
execute query
bind column
fetch
array[id] = picture;
}

print_r(array);
exit;

[Updated on: Sat, 24 October 2015 15:26]

Report message to a moderator

[Message index]

		Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed By: jdrogers73 on Sat, 24 October 2015 15:25
		Re: Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed By: BlackSwan on Sat, 24 October 2015 18:29
		Re: Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed By: jdrogers73 on Mon, 26 October 2015 07:37
		Re: Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed By: BlackSwan on Mon, 26 October 2015 08:36
		Re: Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed By: ThomasG on Thu, 21 January 2016 03:49

Previous Topic:	How to SELECT XMLTYPE data with Perl DBD::Oracle?
Next Topic:	synchronizing data from sql server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:45:00 CDT 2024