Re: Urgent Help for Oracle 8 Stored Procedures with D4 C/S

From: John Seitz <john_seitz_at_protelinc.com>
Date: Tue, 31 Aug 1999 16:57:23 -0400
Message-ID: <7qhfgl$59o$1@news1.cftnet.com>

Does the SP work when ran from SQLPlus?

John

Kai Joußen <kjoussen_at_debitel.net> wrote in message news:37cc3d1d.0_at_news.ivm.net...
> I posted this message also at borland.public.delphi.databases.sqlservers
!!
>
> I have a stored procedure in my Oracle Database which should delete a
> record.
> When i call it i receive the message that UPDATE/INSERT/DELETE is not
> possible in Read-Only-Mode.
> Funny Thing: my procedure for inserting a new record is working fine.
> Can anybody help me very quick? Maybe with sending a running demo code?
> (kjoussen_at_debitel.net)
> I use NT4-Server with Oracle 8.0.5. The Program has a TDatabase (of course
> Readonly=false), TQuery for browsing but RequestLive=False.
> I give the TStoredProc two parameters and call ExecProc. When
> TDatabase.TransIsolation is set to tiDirtyRead jsut simple nothing happens
> when calling the Procedure but when set to tiRepeatableRead i get:
ora-01456
> Insert/update/delete at a read-only-Transaction not allowed.
> Thanx so far
> Kai
>
>
>
>
Received on Tue Aug 31 1999 - 15:57:23 CDT