Zeoslib Portal

Sorry, don't understand your question. StoredProcName combobox (drop-down list) working fine now. Next, when we specify StoredProcName, Zeos look up into metadata for parameters list. If it normal procedure, it get it's parameters. If it packaged procedure (with package name prefix), then parameters...

EgonHugeist, sorry for silence for long time. I just returned from travel. I just tested last SVN snapshot (2415) on Lazarus 1.0.10 (win32). Procedure names now showed correctly, but parameters is empty - they dont't filled on .StoredProcName change. Some log output: 2013-06-24 12:21:46 cat: Execute...

Example 1 Set procedure and parameter name as suggested in StoredProcName an Params editor. StoredProcName="MEAL_PKG.DISABLE_MEAL" Params: MEAL_PKG.L_ID code: ZProc.ParamByName('DISABLE_MEAL.L_ID').AsInteger:=14; ZProc.ExecProc(); TZSQLMonitor reports: 2013-05-31 12:40:24 cat: Connect, pr...

Sorry, i don't know much details about Oracle packages, but i use it just like other Oracle procedures and functions, exept they have package name prefix: standard_procedure(param1, param2) package_name.package_procedure(param1, param2) Parameters names in packages is same, no additional prefixes. N...

Procedure packages don't working with quotes or without quotes - problem in ZStoredProc for Oracle. When i use ZQuery for package procedure call - it working fine: procedure Tdm_ora_main.SaveGrant(Item: TGrant); var Query: TZQuery; begin Query:=ZQuery; if not Query.Connection.Connected then Query.Co...

Try this:

q.Connection := db;
q.SQL.Text := 'select * from ctprod_atalho_titulo where codigo=:codigo';
q.Prepare;
q.ParamByName('codigo').asString := '3';
q.open;

Lazarus 1.0.8 Win7 32 bit Zeos 7.1 alpha SVN rev.2224 Some strange behavior of Oracle stored procedures packages. They showed in procedure list witch quotes, and they params prefixed with procedure name. Procedure name without quotes or in lower case don't working. Even with suggested names procedur...

Example:

Well that's propably right, i know. But i wasn't able to set the ReturnValue to the last place on the list with just one fetch (An issue of the VirtualResultSet vs. Interfaces). So i decided to use two calls do determine if the StoredProcedure can be handled as Procedure or as Function. You can sto...

We can just fetch all parameters by one request. If there param with pos=0, then it ReturnValue. Procedures don't have parameter with pos=0, anyway. I don't have access to database from home, but examples very simple. Function with some parameters: FUNCTION test ( some_id IN NUMBER, some_str OUT VAR...

Examples will be later, after 10 days, sorry.

I notice another flaw - when requesting metadata for function, program perform two requests: for procedure (param number >=1) and for function result (param number = 0). It not bug, but it not good feature.

Oracle 10 / Win32 / Lasarus 1.0.4 / Zeos 7.0.SVN ZProc.StoredProcName:='ADD_DOC'; ZProc.ParamByName('l_mifare_id').AsString:=Account.MifareID; ZProc.ExecProc(); Causes error: EZVariantExeption - Types mismath ZVariant.pas - 395 Backtrace show, that problem in TZOracleCallableStatement.ArrangeInParam...