ORACLE XE

[lordjpe]

I'M BEEN USING DREAMWEABER CS3 WITH JSP AND ORACLE XE. I HAVE A PROBLEM , I CANT COMPLETE THE WIZARD FOR STORE PROCEDURE BECASUE DREAMWEABER ONLY SHOWS TABLES BUT DIDN'T SHOW ME ANY VIEWS OR STORE PROCEDURES, I'M USING JDBC FOR ORACLE XE, I CREATE THE CONNECTION AND THE USER INTO ORACLE WITH THE ROLES OF CONNECT AND RESOURCE.

HOW I CAN FIX IT.
SORRY FOR MY ENGLISH

[Newsgroup_User]

lordjpe wrote:
> I'M BEEN USING DREAMWEABER CS3 WITH JSP AND ORACLE XE. HOWEVER I CANT COMPLETE
> THE WIZARD FOR STORE PROCEDURE BECASUE DREAMWEABER ONLY SHOWS TABLES BUT
> DIDN'T SHOW ME ANY VIEWS OR STORE PROCEDURES, I'M USING JDBC FOR ORACLE XE, I
> CREATE CONNECTION AND MY USER IN ORACLE HAS CONNECT AND RESOURSE ROLES, AND
> THIS IS NOT A SYSTEM USER, NEITHER DBA.
>
> HOW I CAN FIX IT.
>

No need to shout :)

Sounds like Dreamweaver doesn't support stored procedures for Oracle, so
the only thing you can do is create a recordset and call the stored
procedure directly from the SQL.

Steve