Displaying table data through plsql procedure -


i trying display table info through plsql code when executes procedure show procedure successful. not output.please help.

create or replace procedure carinfo  v_serial                car.serial%type; v_cid                   car.cid%type; v_make                  car.make%type ; v_model                 car.model%type; v_cyear                 car.cyear%type; v_color                 car.color%type; v_trim                  car.trim%type; v_enginetype            car.enginetype%type; v_purchinv              car.purchinv%type; v_purchdate             car.purchdate%type; v_purchfrom             car.purchfrom%type; v_purchcost             car.purchcost%type; v_freightcost           car.freightcost%type; v_totalcost             car.totalcost%type; v_listprice             car.listprice%type;  begin  select  serial, cid, make, model, cyear, color, trim, enginetype, purchinv, purchdate, purchfrom , purchcost, freightcost,          totalcost, listprice      v_serial, v_cid, v_make, v_model, v_cyear, v_color, v_trim, v_enginetype, v_purchinv, v_purchdate, v_purchfrom , v_purchcost, v_freightcost,          v_totalcost, v_listprice      car     cid null;  exception  when no_data_found     dbms_output.put_line('no data found')  ;  dbms_output.put_line(v_serial||' ' || v_cid||' ' ||v_make||' ' ||v_model||' ' ||v_cyear||' ' ||v_color||' ' ||v_trim||' ' ||v_enginetype||' ' ||v_purchinv||' ' ||v_purchdate||' ' ||v_purchfrom ||' ' ||v_purchcost||' ' ||v_freightcost||' ' ||         v_totalcost||' ' ||v_listprice); end;

in brief, write procedure following way:

create or replace procedure carinfo l_result_clob clob;  begin    select serial   ||' ' || cid      ||' ' ||make      ||' ' ||model      ||' ' ||cyear||' ' ||          color    ||' ' ||trim      ||' ' ||enginetype||' ' ||purchinv   ||' ' ||          purchdate||' ' ||purchfrom ||' ' ||purchcost ||' ' ||freightcost||' ' ||totalcost||' ' ||listprice     l_result_clob      car    cid null;    dbms_output.put_line(l_result_clob);  exception  when no_data_found     dbms_output.put_line('no data found')  ;  when others     dbms_output.put_line('sqlcode: ' || sqlcode)  ;  end carinfo;

that of course, if columns in select statement convertible character/clob, oracle implicitly convert them, in order concatenation happen.

cheers


Comments

Post a Comment

Popular posts from this blog

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m
Read more

javascript - Z-index in d3.js -

i have map , when hover effect on region of map below yellow line , circle, last ones disappear. how can solve problem? http://jsfiddle.net/ot21n9qx/ var arc = g.append("path") .style("fill", "none") .style("stroke", "yellow") .style("stroke-width", 2) .attr("d", "m" + pathorigin[0] + "," + pathorigin[1] + " q" + svgpoint[0] + "," + pathorigin[1] + " " + svgpoint[0] + "," + svgpoint[1]); var circlesize = d3.scale.linear() .domain([0, 0.5, 1]) .range([4, 10, 4]); svg not have z order draws objects in order created. need create path , circle after create highlight regions. here forked fiddle: http://jsfiddle.net/o00fzgaf/1/
Read more