[patch_done] Oracle - stored procedures packages

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 03.07.2013, 06:25

serbod,

Patch done R2475 \testing-7.1 (SVN)

Can you check my patch? It should solve your current issues.

Hint: The overload case isn't done. I also have to check 'CATALOG'.'STOREDPROC' or 'CATALOG'.'PACKAGE'.'STOREDPROC'. Happens tonight..

UPD: DBA says, that TZSQLProcessor with Oracle reporting some error about wrong line separators. More info will be soon.


Propose to raise a bugtracker-ticket instead.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

serbod
Fresh Boarder
Fresh Boarder
Posts: 20
Joined: 27.12.2012, 09:31

Postby serbod » 03.07.2013, 11:55

It's working now! Thank you!

serbod
Fresh Boarder
Fresh Boarder
Posts: 20
Joined: 27.12.2012, 09:31

Re: [patch_done] Oracle - stored procedures packages

Postby serbod » 03.09.2013, 14:56

Unexpected problem - metadata request for packaged stored procedure gets parameters for all procedures with similar names.

We have procedures:

Code: Select all

some_pkg.some_proc( param_a )
some_pkg.some_proc_one( param_a, param_b )
some_pkg.some_proc_two( param_c )


When we do StoredProcedureName:='some_pkg.some_proc' we get parameters:

Code: Select all

param_a
param_a1
param_b
param_c


I suggest, problem is there (metadata request log) -

Code: Select all

select * from all_arguments where (package_name like 'SOME_PKG%' AND object_name like 'SOME_PROC%' OR package_name like 'SOME_PROC%')
                                                                                 ^^^^ - get all similar names      ^^^^ - and there


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest