Re: SQL+ Switches

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 19 Feb 2004 15:25:32 -0800
Message-ID: <1077233090.561821@yasure>

Mark Day wrote:

> Hi Mark,
> I am actually updating Oracle tables from within MS Access using the sql
> INSERT INTO etc. I need to commit the changes to Oracle instantly and there
> is no way to accomplish this from witih Access. I know the correct way would
> probably be to link to an Oracle view, but a third party would need to be
> involved for this, so the alternative would be to shell out to SQL+ from
> within Access and run the commit command after updating the tables. At
> present this is a manually process and I would like to automate it.
>
> TIA
> Mark.
>
> "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
> news:Vq-dnc5uht8XW67dRVn-jA_at_comcast.com...
>

>>arg1 on the command line (check it out in the manual)
>>
>>    sqlplus scott/tiger_at_mydb
>>
>>however, why sql+ from vb? could you accomplish the same thing by connect

>
> to
>

>>oracle from you VB program? much cleaner and better error handling -- or

>
> do
>

>>you need specified SQL+ features?
>>
>>-- mcs
>>
>>
>>"Mark Day" <mark.day_at_solortec.co.uk> wrote in message
>>news:c10g5n$n7j$1_at_titan.btinternet.com...
>>| Hi all,
>>| Is it possible to pass the logon name and password when opening SQL+?
>>| I need to automate some SQL+ commands and would like to shell out to

>
> SQL+
>

>>| from within VB. I'm not sure whether this could be scripted?
>>|
>>| Any help or pointers to some resources would be very much appreciated.
>>|
>>| TIA
>>| Mark.

Not much of what you have written in this thead computes. Do you have an Oracle DBA where you work that can teach you something about Oracle?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Thu Feb 19 2004 - 17:25:32 CST