Print Thread
Package Wizard bug on Oracle 19c
#60615 10/21/19 02:48 PM
Joined: Aug 2013
Posts: 32
A
akaya Offline OP
Member
OP Offline
Member
A
Joined: Aug 2013
Posts: 32
Hi,

We migrated our development database from 11g to 19c. When we use package manager, procedures with no parameters are omitted from the generated .pas file. Can you check and advise?

Thank you.

Edit: We noticed procedures with no parameters are missing from all_arguments view. This may be related.

Last edited by akaya; 10/21/19 02:53 PM.
Re: Package Wizard bug on Oracle 19c
akaya #60617 10/22/19 08:58 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
We'll investigate and will get back to you.


Marco Kalter
Allround Automations
Re: Package Wizard bug on Oracle 19c
Marco Kalter #60657 11/04/19 02:27 PM
Joined: Aug 2013
Posts: 32
A
akaya Offline OP
Member
OP Offline
Member
A
Joined: Aug 2013
Posts: 32
When can we expect to hear from you?
Thanks.

Re: Package Wizard bug on Oracle 19c
akaya #60658 11/05/19 09:40 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
We have tested this, and it works just fine on 19c. Can you provide a package specification source file that fails for you on 19c? It can be mailed to support@allroundautomations.com.


Marco Kalter
Allround Automations
Re: Package Wizard bug on Oracle 19c
Marco Kalter #60660 11/05/19 11:07 AM
Joined: Aug 2013
Posts: 32
A
akaya Offline OP
Member
OP Offline
Member
A
Joined: Aug 2013
Posts: 32
Package and generated pas has been sent to support@allroundautomations.com.

Last edited by akaya; 11/05/19 11:07 AM.
Re: Package Wizard bug on Oracle 19c
akaya #62646 07/13/21 10:38 AM
Joined: Mar 2005
Posts: 26
Italy
R
Member
Offline
Member
R
Joined: Mar 2005
Posts: 26
Italy
HI Marco, i'm facing same problem. I'm using following DB version:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


When i try to create Delphi interface to a package using Package Wizard all procedures without parameters are not listed and then not interfaced.
Is there the possibility to debug wizard procedure or consult log?

Thank you

Re: Package Wizard bug on Oracle 19c
akaya #64171 08/25/22 07:51 AM
Joined: Aug 2022
Posts: 3
S
Member
Offline
Member
S
Joined: Aug 2022
Posts: 3
see

SOLVED:

Package wizard does not interface procedure without parameters
https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=62685

Last edited by Simon K.; 08/25/22 07:57 AM.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.174s Queries: 15 (0.145s) Memory: 2.5190 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-29 09:41:10 UTC
Valid HTML 5 and Valid CSS