OraFAQ Forum: SQL & PL/SQL » Problems in DDE, TEXT

Home » SQL & PL/SQL » SQL & PL/SQL » Problems in DDE, TEXT_IO, OLE2

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

Problems in DDE, TEXT_IO, OLE2 [message #390304]

Thu, 05 March 2009 16:22

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

ThomasG
Messages: 3212
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

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!

Report message to a moderator

Re: Problems in DDE, TEXT_IO, OLE2 [message #390620 is a reply to message #390583]

Sun, 08 March 2009 15:30

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

UTL_FILE, perhaps?

Report message to a moderator

Re: Problems in DDE, TEXT_IO, OLE2 [message #390621 is a reply to message #390620]

Sun, 08 March 2009 16:27

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!

Report message to a moderator

Re: Problems in DDE, TEXT_IO, OLE2 [message #390634 is a reply to message #390621]

Mon, 09 March 2009 01:46

Frank
Messages: 7901
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.

Report message to a moderator

Re: Problems in DDE, TEXT_IO, OLE2 [message #391050 is a reply to message #390634]

Tue, 10 March 2009 15:58

zyrie15
Messages: 4
Registered: March 2009
Location: Phils

Junior Member

that actually answers a lot. thank you!

Report message to a moderator

Previous Topic:	Pl/Sql Error
Next Topic:	Slow query with rownum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 09 11:19:55 CDT 2025