Skip to main content
L
lordjpe
Participant
October 25, 2007
Question

ORACLE XE

  • October 25, 2007
  • 1 reply
  • 334 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
October 26, 2007
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices