Operating System - HP-UX
1748171 Members
4004 Online
108758 Solutions
New Discussion юеВ

Re: Database query (stored procedure access)

 
prakasse
Advisor

Database query (stored procedure access)

Hi folks,

I have a simple query on the DB cocnept.
Can you let me know your view on this. ...

I have a 32-bit SQL and i plan to move to 64 bit SQL. I use stored procedures in my application.

I can be sure that when i install 64 bit SQL, automatically 64 bit stored procedures will be installed.

But should i change something in my application (i shall retain application as 32 bit) that calls these stored procedure.

Will the application just run like that? or should i modify some part of the application to access the 64 bit stored procedures in SQL?

Thanks,
Senthil
4 REPLIES 4
Eric Antunes
Honored Contributor

Re: Database query (stored procedure access)

Hi Senthil,

Is this an Oracle database? What application do you have??

Best Regards,

Eric Antunes


Each and every day is a good day to learn.
prakasse
Advisor

Re: Database query (stored procedure access)

it's SQL database and application is basically Power builder based.
Steven E. Protter
Exalted Contributor

Re: Database query (stored procedure access)

Shalom,

Oracle databases have upgrade steps outlined at http://technet.oracle.com and http://metalink.oracle.com (software contract required on the later) that convert 32 bit objects to 64 bit.

A test plan to validate functionality is required to make sure this actually works right.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Eric Antunes
Honored Contributor

Re: Database query (stored procedure access)

Hi Senthil,

I did a google search and found this google group that seems to answer your question:

http://groups.google.com/group/powersoft.public.powerbuilder.connectivity/browse_thread/thread/b65880fd60459293/5b6b4c1eac588ffc?#5b6b4c1eac588ffc

It seems that Powerbuilder communicates via ODBC so it should be fine.

Anyway, it is always a good idea to contact your application support/representative...

Best Regards,

Eric Antunes
Each and every day is a good day to learn.