• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Delphi3.0 & BDE5.0 with Oracle 8.0.4

I'm trying to connect Oracle,  through it's native drivers,
I got success in that.
But i'm not able to pass more than 10 parameters
through stored procdures.
Is there's  any patch for BDE i need to do.
0
Vinnny
Asked:
Vinnny
Advertise Here
  • 3
1 Solution
 
qdyoungCommented:
Maybe you must switch to Delphi4. Delphi4 add many new features to support Oracle8. I'am now using Delphi4(build 5.37) with SP2 and BDE5.01 with Oracle8.0.4. I get no problem. I think that your problem is not just lies in BDE.

Regards. Young.
0
 
VinnnyAuthor Commented:
Young!
Hi Young Thanx.
I got pakages in Oracle 8.0.4.
It has got more than 12 parameters in some procedures
like

PROCEDURE PK_Set_Engine ( pCall_Level in NUMBER,
                          pCLNT_Key in Client.CLNT_Key%TYPE,
                          pCLNT_STAT_Key in Employer.EMPR_STAT_Key%Type,
                          pCLNT_PAYS_SOCIAL_SECURITY in                                                    Employer.EMPR_PAYS_SOCIAL_SECURITY%TYPE,
                          pCLNT_PAYS_MEDICARE in                                                                  Employer.EMPR_PAYS_MEDICARE%Type,
                          pCLNT_Name in Organization.ORGZ_Legal_Name%Type,
                          pCLNT_DBA in Organization.ORGZ_DBA_Name%Type,
                          pCLNT_FID in Organization.ORGZ_FID%Type,
                          pCLNT_QUANTEC_CODE in Client.CLNT_Quantec_Code%TYPE,
                          pCLNT_PRCM_KEY in Client.CLNT_PRCM_Key%Type,
                          pCLNT_EXFM_KEY in Client.CLNT_EXFM_Key%Type,
                          pCLNT_AT_PAYROLL_START_DATE in                                                 Client.CLNT_AT_PAYROLL_START_DATE%Type)

1.Do you think this problem(parameters) will be alright if I use Delphi 4.0.
   Because right now i'm using Oracle 8.0.4 - Delphi 3.0 - BDE 5.01.
2.Do you get any memory leaks problem?

Thanx , let me know.

Vinod.
0
 
VinnnyAuthor Commented:
Young!
Hi Young Thanx.
I got pakages in Oracle 8.0.4.
It has got more than 12 parameters in some procedures
like

PROCEDURE PK_Set_Engine ( pCall_Level in NUMBER,
                          pCLNT_Key in Client.CLNT_Key%TYPE,
                          pCLNT_STAT_Key in Employer.EMPR_STAT_Key%Type,
                          pCLNT_PAYS_SOCIAL_SECURITY in                                                    Employer.EMPR_PAYS_SOCIAL_SECURITY%TYPE,
                          pCLNT_PAYS_MEDICARE in                                                                  Employer.EMPR_PAYS_MEDICARE%Type,
                          pCLNT_Name in Organization.ORGZ_Legal_Name%Type,
                          pCLNT_DBA in Organization.ORGZ_DBA_Name%Type,
                          pCLNT_FID in Organization.ORGZ_FID%Type,
                          pCLNT_QUANTEC_CODE in Client.CLNT_Quantec_Code%TYPE,
                          pCLNT_PRCM_KEY in Client.CLNT_PRCM_Key%Type,
                          pCLNT_EXFM_KEY in Client.CLNT_EXFM_Key%Type,
                          pCLNT_AT_PAYROLL_START_DATE in                                                 Client.CLNT_AT_PAYROLL_START_DATE%Type)

1.Do you think this problem(parameters) will be alright if I use Delphi 4.0.
   Because right now i'm using Oracle 8.0.4 - Delphi 3.0 - BDE 5.01.
2.Do you get any memory leaks problem?

Thanx , let me know.

Vinnny.
0
 
VinnnyAuthor Commented:
Hi qdyoung!

 I'm waiting for ur response!!!

Thanx
Vinnny.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Access It Now
  • 3
Advertise Here
Tackle projects and never again get stuck behind a technical roadblock.
Join Now