Zeoslib Portal

Hi all, Please i dont know how read output parameters from stored procedure (oracle 10g) this is my trivial proc: create or replace PROCEDURE TEST_p ( test_out OUT NUMBER ) AS BEGIN select count(id) into test_out from cislovaci_plan; END TEST_p; and I tried this: q := TZQuery.Create(self); q.Connect...

Thanks for reply!

On this i know too. But why from the ORACLE developer myPROC is pass success? I dont understand it. :0(( So im going search error in proc.

Thank you

Hi all, I have a stored procedure in my db (oracle 10g enteprise) with name "myPROC". This procedure have one parameter type text with name "table". Procedure process perhaps 350 000 records by cursor. When i call procedure from etc. ORACLE developer by SQL command so operations ...

Hello, I have this problem. i use oracle 10g db and there i have table with field of NUMBER datatype. There i have value (number) with decimal point etc. (0.45). i using zeos 6.6.6 . so and when i open select query that result is 4 (original in db is 4.58). when i open this query in sql developer th...

What version of zeoslib are you using? With Zeos 6.6 you could try setting ZQuery.FetchRow to a value different from zero. But most depends on the way the DBGrid fetches the data from the ZQuery. If it just fills all data until end-of-resultset this won't help us. Mark I had version of Zeos 6.5 . :...

Hello, I am from Czech Republic so excuse my English. I am programing database application for ORACLE with ZEOS components. And i want open Query with 9x.xxx record, but showing is very slowly. Can you help me please??? How showing all record fast or how fetch first 1000 record to DBgrid and on scro...

mdaems wrote:Yes, but I suppose you already saw the promise made be Rodrigosd in this post : http://zeos.firmos.at/viewtopic.php?t=2558 . His solution would be helpfull for you.

Mark

SUPER , thak you very much.

I know ...

I Can't use table name ori view name or atributte name as parameter :0(((

Hi all, i am from czech republic so promise me my english. I have problem with ZQuery. In Zquery.SQL have: select * from :TAB ParamsCheck i have active (true). So and now i want set the parameter by command: Query.ParamByName('TAB').AsString := 'myTable'; Query.Open; Application throw mesage: "...