Oracle Question

[shamrox]

Hey All,

I had a potential customer ask me this question:

I plan to host my site and interface with an Oracle database. I notice that you provide an Oracle 10g tablespace along with 2 users (based on your Silver host plan). Does this account allow for pl/sql procedure and packages?

Will I have the ability to return REF CURSORS to my ASP pages?

Can someone help me answer this?

 

[Yash]

pl/sql procedures yes.
Packages and ref cursors I'll need to confirm this with our Oracle DBA and would let you know within 24 hours

 

[Yash]

I am pretty sure the answer to Ref cursors and packages are a Yes as well, but give me time to confirm.

 

[shamrox]

thanks....I will wait to answer the question.

 

[shamrox]

Yash have you found out anything?

 

[shamrox]

Can I find out the answer?

 

[Stephen]

It hasn't been 24 hours, the DBA is not available right now.

 

[Yash]

both are supported

but ref cursors are not really recommended because they can cause lock issues

 

[shamrox]

Hey Yash,

Can we run an ASP application running against an Oracle Database via Oracle Ref Cursors. Connecting through ODBC. Is this the configuration that you provide?

 

[Yash]

Shamrox, to be honest we haven't setup something like this yet.

But we could work on a desired setup using ref cursors