databasesetup.sql

来自「房间信息,可以打开」· SQL 代码 · 共 26 行

/*
* @author  Jagriti
* @version 1.0
*
* Name of the Application        :  DatabaseSetup.sql
* Creation/Modification History  :
*
* Jagriti      26-Sep-2002     Created
*
* Overview of Script        :
*   
* This script creates a Database Stored Procedure "GET_ROOM_DETAILS" 
*/

PROMPT 'Creating Java Stored Procedure GET_ROOM_DETAILS....'

CREATE  OR REPLACE PROCEDURE GET_ROOM_DETAILS( HOTEL_ID  IN VARCHAR2,
                                               ROOM_TYPE  IN  VARCHAR2,
                                               NUM_ROOMS_AVAILABLE  OUT NUMBER,
                                               STANDARD_RATE  OUT  NUMBER ) AS
LANGUAGE JAVA NAME 'RoomsInformationProcedure.getRoomDetails(java.lang.String, java.lang.String, int[], float[])';

/
SHOW ERRORS