Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Objects for OLE (OO4O) and scripting
I was looking for a method that returns the ddl SQL for an object. For
example, for a table, I wanted to get the "create table MyTable .... etc"
sql.
"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
news:e37lpv$3eq$1_at_nntp.fujitsu-siemens.com...
> arch schrieb:
>> How is it done? What method do you call.
> What exactly do you want?
> OO4O has lots of classes, leading to objects such as
> orasession or oradatabase, as you can see from the help file.
> There are various ways to work with them, from createobject
> to methods in the objects themselves.
> As for examples, they are in the help too.
> You can use them from your VBScript or JSctipt. Is that what
> you mean by scripting an object?
> As for statement extraction, the documentation (again!)
> shows you the OraSQLStmt object. Which has a property called "SQL",
> which returns or sets the sql code to be executed.
>
> If that's not what you want, maybe you could be a bit more
> precise as to what you mean by "object" and "scripting".
>
>> I haven't been able to find one. Can you give me an example (eg in vb).
>>
>> "Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in
>> message news:efmdnWk6zq5GhcvZRVn-rg_at_comcast.com...
>>> "arch" <archangel_at_arach.net.au> wrote in message
>>> news:1146481395.519835_at_angel.amnet.net.au...
>>>> Hi. Is it possible to use Oracle Objects for OLE to script an object
>>>> (extract the create statement DDL).
>>>>
>>>>
>>> Yes.
>>> Jim
>>>
>>>
>>
>>
>
> Lots of Greetings!
> Volker
Received on Tue May 02 2006 - 08:59:01 CDT