StoredProc

Article View: pl.comp.lang.delphi.bazy-danych

Article #70693

Back to pl.comp.lang.delphi.bazy-danych Previous Next

#70693

From: t.byczkowski
Date: Thu, 30 Aug 2007 08:22

26 lines
1823 bytes

Witam,
mam problem z obsługa procedury z oracla w Delphi 2007 pro
W przy ExecProc  mam komunikat
'general SQL error'  Microsoft ODBC driver for orcle- błąd składniowy
lub naruszenie zasad
dostępu.
użytkownik Oracle ma oczywiście wszystkie prawa do wykonywania
procedury. W sqlplus działa.
 procedure TForm13.MaskEdit1Exit(Sender: TObject);

begin
     with StoredProc1 do
     begin
     Close;
        Try
          ParamByName('pdno').AsInteger := 2;
          ExecProc;
        Except
           On EDBEngineError Do
              MessageDlg('Zle', mtError,mbOk,0);
     End;

 End;

Z delphi dopiero zaczynam także będę wdzięczny za info
pozdrawiam

Technical Details

Message-ID: <1188462159.603515.83760@y42g2000hsy.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newspeer2.se.telia.net!newspeer3.se.telia.net!se.telia.net!proxad.net!feeder1-2.proxad.net!64.233.178.134.MISMATCH!postnews.google.com!y42g2000hsy.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newspeer2.se.telia.net!newspeer3.se.telia.net!se.telia.net!proxad.net!feeder1-2.proxad.net!64.233.178.134.MISMATCH!postnews.google.com!y42g2000hsy.googlegroups.com!not-for-mail
From: t.byczkowski@stako.pl
Newsgroups: pl.comp.lang.delphi.bazy-danych
Subject: StoredProc
Date: Thu, 30 Aug 2007 01:22:39 -0700
Organization: http://groups.google.com
Lines: 27
Message-ID: <1188462159.603515.83760@y42g2000hsy.googlegroups.com>
NNTP-Posting-Host: 80.55.61.166
Mime-Version: 1.0
X-Trace: posting.google.com 1188462159 7037 127.0.0.1 (30 Aug 2007 08:22:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 30 Aug 2007 08:22:39 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: y42g2000hsy.googlegroups.com; posting-host=80.55.61.166;   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit