topic Re: Database query (stored procedure access) in Operating System - HP-UX

Database query (stored procedure access)

prakasse — Fri, 12 Dec 2008 09:45:35 GMT

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

Re: Database query (stored procedure access)

Eric Antunes — Mon, 15 Dec 2008 12:01:21 GMT

Hi Senthil,

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

Best Regards,

Eric Antunes

Re: Database query (stored procedure access)

prakasse — Mon, 15 Dec 2008 12:09:01 GMT

it's SQL database and application is basically Power builder based.

Re: Database query (stored procedure access)

Steven E. Protter — Mon, 15 Dec 2008 12:28:39 GMT

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

Re: Database query (stored procedure access)

Eric Antunes — Mon, 15 Dec 2008 13:00:46 GMT

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