Database query (stored procedure access)

[prakasse]

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

[Eric Antunes]

Hi Senthil,

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

Best Regards,

Eric Antunes

[prakasse]

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

[Steven E. Protter]

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

[Eric Antunes]

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