[patch_done] Oracle - stored procedures packages

[EgonHugeist]

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.

[serbod]

It's working now! Thank you!

[serbod]

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