Home » SQL & PL/SQL » SQL & PL/SQL » Problems in DDE, TEXT_IO, OLE2
Problems in DDE, TEXT_IO, OLE2 [message #390304] Thu, 05 March 2009 16:22 Go to next message
zyrie15
Messages: 4
Registered: March 2009
Location: Phils
Junior Member
I just want to ask if anyone knows the reason why you could never use those codes in database procedures/packages? You see, I know that I can't use it, but I don't know why. I've been searching for it on the web but it seems like I couldn't get a reasonable answer.

And if you can't use it, are there equivalent codes to use? it is for generating excel files as a db procedure... I just don't know how to convert it from library to db proc because I can't use those codes there.

Thank you so much for replying! (I really really need to know...)

[Updated on: Thu, 05 March 2009 16:27]

Report message to a moderator

Re: Problems in DDE, TEXT_IO, OLE2 [message #390305 is a reply to message #390304] Thu, 05 March 2009 16:33 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Because they are specific to run in/with Forms on the client, not to be run on the Server.

So it basically is a similar reason like why it's a bad idea to use a truck on the ocean or a ship on the highway.

[Updated on: Thu, 05 March 2009 16:33]

Report message to a moderator

Re: Problems in DDE, TEXT_IO, OLE2 [message #390583 is a reply to message #390304] Sat, 07 March 2009 16:54 Go to previous messageGo to next message
zyrie15
Messages: 4
Registered: March 2009
Location: Phils
Junior Member
sir thanks for replying! but is it possible that you know some alternative solutions for this problem of mine? i mean, are there codes in the server side that functions the same as those three i've been asking? thank you so much!
Re: Problems in DDE, TEXT_IO, OLE2 [message #390620 is a reply to message #390583] Sun, 08 March 2009 15:30 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
UTL_FILE, perhaps?
Re: Problems in DDE, TEXT_IO, OLE2 [message #390621 is a reply to message #390620] Sun, 08 March 2009 16:27 Go to previous messageGo to next message
zyrie15
Messages: 4
Registered: March 2009
Location: Phils
Junior Member
thank you sir for your reply!

i've scanned it for a bit (i was planning to try it on the office) and it looked like a good alternative for text_io. sir, is it even possible to find an ole2 and dde alternative to use in writing packages? thanks in advance!
Re: Problems in DDE, TEXT_IO, OLE2 [message #390634 is a reply to message #390621] Mon, 09 March 2009 01:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You should be aware of the main difference between the forms-packages you mention and packages in the database: the forms-packages are about Client-side processing, TEXT-IO creates client-side files.
Database packages run on the server side.
It will not be possible to interfere with a clients Excel program using OLE from a database package.
Re: Problems in DDE, TEXT_IO, OLE2 [message #391050 is a reply to message #390634] Tue, 10 March 2009 15:58 Go to previous message
zyrie15
Messages: 4
Registered: March 2009
Location: Phils
Junior Member
that actually answers a lot. thank you!
Previous Topic: Pl/Sql Error
Next Topic: Slow query with rownum
Goto Forum:
  


Current Time: Sat Dec 03 17:55:18 CST 2016

Total time taken to generate the page: 0.04153 seconds