Добрый день.

Вопрос:
как создать прграммно (ABAP) FUNCTION / PROCEDURE
в ORACLE...синтакс известен, но может у кого то есть живой пример?

CREATE [OR REPLACE] FUNCTION function_name
[ (parameter [,parameter]) ]
RETURN return_datatype
IS | AS
[declaration_section]
BEGIN
executable_section
[EXCEPTION
exception_section]
END [function_name];

по аналогии с CREATE TABLE / VIEW не получается...

REPORT 1.
*Create connection to Oracle
EXEC SQL.
CONNECT TO :'CS1E'
ENDEXEC.
CHECK sy-subrc = 0.
*Create Table
EXEC SQL.
CREATE TABLE ZBWDELTA (
QUALIF CHAR(000004) NOT NULL ,
ROW_ID VARCHAR2(000015) NOT NULL ,
LOADOK CHAR(000001) ,
LDATUM DATE,
LSCHKZ CHAR(000001) ,
LREQST VARCHAR2(000030) ,
LRUSER CHAR(000012) ,
PRIMARY KEY (QUALIF, ROW_ID)
)
ENDEXEC.
WRITE:/ sy-subrc.


REPORT 2.
*Create connection to Oracle
EXEC SQL.
CONNECT TO :'CS1E'
ENDEXEC.
CHECK sy-subrc = 0.
*Create View
EXEC SQL.
CREATE VIEW V_T1T2
(ROW_ID,
T1F1,
T1F2,
T2F1,
T2F2)
AS SELECT
T1.ROW_ID,
T1.T1F1,
T1.T1F2,
T2.T2F1,
T2.T2F2
FROM T1, T2
WHERE
T1.ROW_ID = T2.ROW_ID


ENDEXEC.
WRITE:/ sy-subrc.

**Create T1
*EXEC SQL.
* CREATE TABLE T1 (
* ROW_ID VARCHAR2(000015) NOT NULL ,
* T1F1 CHAR(10),
* T1F2 CHAR(10),
* PRIMARY KEY (ROW_ID)
* )
*ENDEXEC.
*WRITE:/ sy-subrc.
**Create T2
*EXEC SQL.
* CREATE TABLE T2 (
* ROW_ID VARCHAR2(000015) NOT NULL ,
* T2F1 CHAR(10),
* T2F2 CHAR(10),
* PRIMARY KEY (ROW_ID)
* )
*ENDEXEC.
*WRITE:/ sy-subrc.



заранее спасибо
Юрий

а прав хватит на oracle для создания функций и таблиц на DML ?

xwatit...
DBConnect sdelan 4ere3 pol3owatelia siebel
( eto w Siebel-ORA kak SAP_ALL w SAP )