sql - Apex. Calling proc within htp.prn? -


i'd know, how call proc under button in apex. here steps perform me: -adding blank page in application -adding button exp. bellow region -adding dynamic action pl/sql button -choosing action execute pl/sql -adding pl/sql code below

pl/sql code:

begin wycen_pojazd('audi', 'a4', 2013, 'diesel', 2000) end;

pl/sql procedure i'm talking about:

create or replace procedure wycen_pojazd (  p_marka in baza_eurotax.marka%type,  p_model in baza_eurotax.model%type,  p_rok_prod in baza_eurotax.rok_produkcji%type,  p_paliwo in baza_eurotax.rodzaj_paliwa%type,  p_pojemnosc in baza_eurotax.pojemnosc%type )  ex_wycena baza_eurotax.wycena%type; begin  select wycena ex_wycena  baza_eurotax  marka = p_marka        , model = p_model        , rok_produkcji = p_rok_prod        , rodzaj_paliwa = p_paliwo        , pojemnosc = p_pojemnosc; if ex_wycena > 0         htp.prn('wycena katalogu eurotax' || <br > ||                           'twój pojazd został wyceniony na: ' || ex_wycena ||                           ' pln.');  end if;  exception   when others    htp.prn('wprowadzony pojazd nie został znaleziony w bazie eurotax. w trakcie zawierania ubezpieczenia, prosimy                         o powołanie się na wartość pojazdu jaka została zapisana na dokumencie potwierdzającym nabycie pojazdu.' || <br > ||                         'dziĘkujemy!'); end wycen_pojazd;

proc written under polish user.

htp.p - it's not working too.

thanks lot helping me through apex. i'm new this.

instead of calling htp.prn assign value apex_application.g_print_success_message. after message shown in next page in default success box.


Comments

Post a Comment

Popular posts from this blog

c# - Validate object ID from GET to POST -

i have method allows user access comment have made on site. have post method lets them update comment. my normal solution send entire comment model through, let them update it, update on database when post back. involve sending commentid through in hiddenfor , can manipulated. how can verify commentid sent in get method same i'm getting in post , not able alter comment wish? how can verify commentid sent in method same i'm getting in post? basically have validate following things in post - user logged-in user. authenticated users post comments. commentid in post , should valid commentid , should present in database. userid associated logged-in user should same userid associated comment . comment should contain userid column, can check @ time of update. to make sure update happens comment has been sent in get - hold commentid in session , in post action compare commentid value in session .
Read more

node.js - Custom Model Validator SailsJS -

when using custom model validator checks record within model. return within spread doesn't seem end control flow. //post.js model /** * custom validator **/ types: { isuservalid: function(user_id) { var promise = require('bluebird'); promise.all([ user.findone({id: user_id}) ]) .spread(function(user) { console.log(user); if (user === null || user === undefined) { console.log('failed'); return false; }else{ console.log('passed'); return true; } }); } }, my response standard validation failed response. { "error": "e_validation", "status": 400, "summary": "1 attribute invalid", "model": "post", "invalidattributes": { "owner": [ { "rule": "isuservalid", ...
Read more

php - Find a regex to take part of Email -

i have following emails need extract part from: bestellnummer xxx: 1 von xxx, 1er pack ------------- anfang der nachricht ------------- foo bar baz foo bar baz // <<<<< need text here ------------- ende der nachricht ------------- ------------- anfang der nachricht ------------- foo bar baz foo bar baz ------------- ende der nachricht ------------- there 0 unlimited occurences of ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- and i'm able extract first part regex: $re = "/------------- .*? -------------.?(.*?).?------------- .*? -------------/s"; but, i'm quite new on learning regex, i'm pretty sure there must better regex extract part (foo bar baz foo bar baz) of text between ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- as can in different languages, i'm using .? to match between hyphens. i...
Read more