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?
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
I am pretty sure the answer to Ref cursors and packages are a Yes as well, but give me time to confirm.
thanks…I will wait to answer the question.
Yash have you found out anything?
Can I find out the answer?
It hasn’t been 24 hours, the DBA is not available right now.
both are supported
but ref cursors are not really recommended because they can cause lock issues
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?
Shamrox, to be honest we haven’t setup something like this yet.
But we could work on a desired setup using ref cursors