by" ausnützen (d.h. die Routine bzw der Type/die Function kann nur in diesem Package verwandt werden!)
Di... -----------------------------------------------
function encrypt (p_plaintext varchar2)
return raw
... -----------------------------------------------
function decrypt (p_encryptedtext raw)
return varchar2... -----------------------------------------------
function getuserpwd (p_slot number,p_private_key varchar2
).
Der Java Script Block wird auf Page Ebene in "Function and Global Variable Declaration" hinterlegen.
D... e
// build the dataset from all rows of the table
function getDataSet( table_rows ,pkRowName) {
var elem... ar data_row = {};
table_rows.each(
function (idx,elem) {
// read one row o... t('tr').children().each(
function (idx,elem) {
// read
1000 ms warten und prüfen
tmr.alarm(1, 1000, 1, function()
-- prüfe ob die Verbindung schon geklappt hat
... .create()
ntptimer:register(1000, tmr.ALARM_AUTO, function()
-- prüfe ob die Verbindung schon geklappt hat
... y = wifi.sta.getip()
sntp.sync(gateway,
function(sec, usec, server, info)
print('sync', se... ver)
rtctime.set(sec, 0)
end,
function()
print('Time Sync was not sucessfull')
==========================================+
-- function : connectAD
-- +===========================================================+
function connectad
return dbms_ldap.session;
-- +===... ==============================================+
function readgroups(
p_session dbms_ldap.session ,
... ==========================================+
-- function : getADPWD
-- get the Password for the AD Use
S OBJECT
(
g_string VARCHAR2(32767),
STATIC FUNCTION ODCIAggregateInitialize(sctx IN OUT t_string_agg)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateIterate(self IN OUT t_string_agg,... IN VARCHAR2 )
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateTerminate(self IN t_string... IN NUMBER)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateMerge(self IN OUT t_string_agg,
String qualifizieren]]
* [[prog:oracle_reverse_function|Einen String in SQL mit reverse umdrehen]]
* [... rog:oracle_analytic_functions_lag|Oracle Analytic Function - Beispiel 1 - Lücken in einem Datenstrom finden]... g:oracle_analytic_functions_top_n|Oracle Analytic Function - Beispiel 2 - Top N Query]]
* [[prog:oracle_analytic_functions_doubletten|Oracle Analytic Function - Beispiel 3 - Doppelte Daten finden und löschen]
aScript Code für die Seite unter "Page/JavaScript/Function and Global Variable Declaration" abgelegt:
<code... ods for the handling of the results
$.showMyError=function(jqXHR, textStatus, errorThrow){
var message_t... }
// set my Element on the page
$.setPageItem = function (json) {
console.log(json);
var textJson=... something
// show spinner popup
$.onBeforeSend=function(jqXHR ,settings) {
console.log(settings);
index by binary_integer;
function showCreditCardType (p_number varchar2)
retu... ss - is a Luh10 Number
-1 Invalid
*/
function checkLuhnMod10 (p_number number)
return int... string and search for valid creditcards
*/
function analyseCCText (p_text varchar2)
return varc... arreturn constant varchar2 (2) := '
';
function getCCfromList (p_list OWA_UTIL.ident_arr
e javascript>
// sleep time expects milliseconds
function sleep (time) {
return new Promise((resolve) =... gpi",
connectString : "10.10.10.1/GPI"
},
function(err, connection)
{
if (err) { console.error... lect sysdate || ' --- Result ' from dual ",
function(err, result)
{
if (err) { console.e... "-- Info -- try to init oracle -");
// Pool Function
oracledb.createPool (
{
user : "g
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
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
DING (data_type_in) RETURN <data_type_out> USING <function_name>;
</code>
Ein Vorteil gegenüber der Verwe... DING (data_type_in) RETURN <data_type_out> USING <function_name>,
(data_type_in) RETURN <data_type_out> USING <function_name>;
</code>
Verwendung findet diese Art vo... unktionen anlegen==
<code sql>
create or replace function string_eq (p_wert1 varchar2, p_wert2 varchar2)
re
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(
je nach Bedarf konvertieren
--
create or replace function readRawtoVarchar2(p_id number)
return varchar2
as... msetzung für die Tabelle T003T
CREATE OR REPLACE FUNCTION readRawtoVarchar2T003T(p_key varchar2)
RETURN var...
-- Hilfsfunktion definieren
create or replace function read(p_cursor sys_refcursor) return varchar2 is
... Test Hilfsfunktion für PL/SQL
create or replace function read(p_cursor sys_refcursor) return varchar2 is