Article View: pl.comp.lang.delphi.bazy-danych
Article #82706Re: ZEOS 7.3 i StoredProc ... i wogóle
From: miab
Date: Sat, 08 Oct 2016 12:55
Date: Sat, 08 Oct 2016 12:55
31 lines
1910 bytes
1910 bytes
W dniu 2016-10-07 o 21:59, miab pisze: > W dniu 2016-10-07 o 14:46, Morff pisze: >> Próbuję zaprząc ZEOSA do roboty z Oracle. >> I jakoś przy StoredProc nie chcą się automatycznie tworzyć parametry : >> >> prc.StoredProcName := schema_+'.'+package_+'.'+procname_; >> prc.prepare; >> >> no i prc.paramcount = 0 >> > > A u mnie taki zestaw instrukcji jak najbardziej kompiluje się, działa i > daje sensowne wyniki: > > ZStoredProc1.Close; > ZStoredProc1.StoredProcName:='ADQA_TESTBINDING'; > Edit1.Text:=IntToStr(ZStoredProc1.Params.Count); > ZStoredProc1.Params[0].Value:=12.367; > ZStoredProc1.Params[1].Value:='zupa'; > ZStoredProc1.ExecProc; > Edit2.Text:=ZStoredProc1.Params[0].AsString+' > '+ZStoredProc1.Params[1].AsString; > ZStoredProc1.Open; > > miab > powinno być(ciekawiej): Edit2.Text:=ZStoredProc1.Params[0].AsString+ZStoredProc1.Params[1].AsString+ZStoredProc1.Params[2].AsString+ZStoredProc1.Params[3].AsString; miab
Technical Details
Message-ID:
<ntaqhf$cfm$1@node1.news.atman.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mailReferences:
<5a30eeb3-d080-4f78-952c-9aba4deda341@googlegroups.com> <nt8v02$e7g$1@node1.news.atman.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail From: miab <miwa14@wp.pl> Newsgroups: pl.comp.lang.delphi.bazy-danych Subject: Re: ZEOS 7.3 i StoredProc ... i wogóle Date: Sat, 8 Oct 2016 14:55:59 +0200 Organization: ATMAN - ATM S.A. Lines: 31 Message-ID: <ntaqhf$cfm$1@node1.news.atman.pl> References: <5a30eeb3-d080-4f78-952c-9aba4deda341@googlegroups.com> <nt8v02$e7g$1@node1.news.atman.pl> NNTP-Posting-Host: 89-79-241-203.dynamic.chello.pl Mime-Version: 1.0 X-Trace: node1.news.atman.pl 1475931503 12790 89.79.241.203 (8 Oct 2016 12:58:23 GMT) X-Complaints-To: usenet@atman.pl NNTP-Posting-Date: Sat, 8 Oct 2016 12:58:23 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows NT 10.0; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 In-Reply-To: <nt8v02$e7g$1@node1.news.atman.pl> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit