sehr simples Macro:
<code sql>
create or replace function customerId
return varchar2
SQL_MACRO(SCALAR)
as
... g PLSQL nativ ==
<code plsql>
create or replace function getInteralKDNr( p_institut varchar2
... deln
Das SQL Macro:
<code sql>
create or replace function getInteralKDNrSQM
return varchar2
SQL_MACRO(SCALA... rbedingung einbauen:
<code sql>
create or replace function getZentralKundenTabSQM
return varchar2
SQL_MACRO(
ault
The setting named: security.requestValidationFunction was set to: ords_util.authorize_plsql_gateway in ... Pool
security.requestValidationFunction ords_util.authorize_plsql_gateway Pool
</co
ault
The setting named: security.requestValidationFunction was set to: wwv_flow_epg_include_modules.authoriz... Pool
security.requestValidationFunction wwv_flow_epg_include_modules.authorize Pool
... granted execute privilege on the procedure, or a function specified by security.requestValidationFunction configuration property has prevented access Action: Check t
^.+[@].*google[[:punct:]]com$', 'i')
</code>
=== Function based index ===
Auch für ein REGEXP kann ein "Function Based" Index ( Siehe [[http://docs.oracle.com/cd/E1... rver.112/e25494/indexes.htm#ADMIN11730|Creating a Function-Based Index]] hilfreich sein.
==== RegEx und ... dann prüfen
-----------------------------------
function validateEMail( p_email varchar2 default null)
re
s der DB";
}
}
/
create or replace function helloWorld
return varchar2
as language java
name... allo, ich bin Java aus der DB
CREATE OR REPLACE FUNCTION getJavaProperty(myprop IN VARCHAR2)
RETURN VARCHA
n wie zum Beispiel:<code plsql>
CREATE OR REPLACE FUNCTION callExternalDDLProc
RETURN VARCHAR2 AS LANGUAGE... ERROR at line 1:
ORA-06521: PL/SQL: Error mapping function
ORA-06522: Unable to load symbol from DLL
</code... thode erzeugt der Wizard diesen Code:
<code sql>
FUNCTION GETDATA RETURN VARCHAR2 AUTHID CURRENT_USER IS
BE... LEARPARAMETERS;
RETURN DBMS_CLR.EXECUTEVARCHARFUNCTION('SKAMQCONNECT_DLL', 'SKAMQConnect.Class1', 'getDa
igenen Funktion im With Block:
<code sql>
with
function add_weeks(p_d date,p_w number)
return date
is
...
</code>
<code sql>
CREATE OR REPLACE FUNCTION intervalToSeconds(
p_Minuend TIMESTAMP , p_
ion-express/19.1/aeapi/PUBLIC_CHECK_AUTHORIZATION-Function-DEPRECATED.html
Beispiel Code :
<code plsql>
create or replace function checkRowAccess( p_row_val varchar2