oracle - How to run this stored procedure -

-

i have check procedure

im giving following values parameters 

34220, 2815,'7/20/2011', 32760, 100, 'pmnt_check', 1, null, "", false, null, null  declare   p_app_id number;   p_user_id number;   p_date date;   p_inv_ids wb_prod.wb_pck_types.t_ids;   p_amnts wb_prod.wb_pck_types.t_numbers;   p_pmnt_method varchar2(15);   p_bank_ac_from number;   p_check_numbers wb_prod.wb_pck_types.t_numbers;   p_memo varchar2(1000);   p_pay_multiple number;   p_crd_ids wb_prod.wb_pck_types.t_ids;   p_crd_amounts wb_prod.wb_pck_types.t_prices;   o_py_id number; begin   p_app_id := 34220;   p_user_id := 2815;   p_date := '7/20/2011';   -- modify code initialize variable   p_inv_ids := 32760;   -- modify code initialize variable   p_amnts := 100;   p_pmnt_method := 'pmnt_check';   p_bank_ac_from := 1;   -- modify code initialize variable  --p_check_numbers := null;   p_memo := '';   p_pay_multiple := false;   -- modify code initialize variable   -- p_crd_ids := null;   -- modify code initialize variable   -- p_crd_amounts := null;    wb_pck_bill_payments.pay_bills(     p_app_id => p_app_id,     p_user_id => p_user_id,     p_date => p_date,     p_inv_ids => p_inv_ids,     p_amnts => p_amnts,     p_pmnt_method => p_pmnt_method,     p_bank_ac_from => p_bank_ac_from,     p_check_numbers => p_check_numbers,     p_memo => p_memo,     p_pay_multiple => p_pay_multiple,     p_crd_ids => p_crd_ids,     p_crd_amounts => p_crd_amounts,     o_py_id => o_py_id   );   dbms_output.put_line('o_py_id = ' || o_py_id); end;

im getting error @ line 

 p_inv_ids := 32760;

i checked type of 

p_inv_ids wb_prod.wb_pck_types.t_ids;

which in declare statement, this

type t_ids table of t_id    index binary_integer;

i donot understand how give parameter type. please let me know how give parameter.

thank

p_inv_ids associative array per type declaration.

you can not assign way 

p_inv_ids := 32760;

you need specify index in p_inv_ids assigning value

something like

p_inv_ids(0) := 32760; p_inv_ids(1) := 32761;

http://www.java2s.com/tutorial/oracle/0520__collections/assignvaluetoplsqltable.htm


Comments

Post a Comment

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

-
my group , running server based upon django , uses mod_wsgi run apache server. not working on project after over, attempting set cronjob similar functionality check if apache server has shut down(system restart or power failure), , if has, restart server me. i've found documentation on how check if apache server down , restart server if is, our server uses https , our start command pretty verbose. can use functionality provided in these examples: https://askubuntu.com/questions/277389/cron-job-to-restart-apache https://www.digitalocean.com/community/tutorials/how-to-use-a-simple-bash-script-to-restart-server-programs or need more complicated process make happen? the command use start server is python manage.py runmodwsgi --host 0.0.0.0 --port 8001 --https-port 8000 --ssl-certificate (certificate location) --server-name (domain name) i'm pretty new linux , using both mod-wsgi apache appreciated. you better off using --setup-only option mod_wsgi-expres...
Read more

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines. ...
Read more

jQuery Ajax Render Fragments OR Whole Page -

-
i'm in throes of building application wraps mess of legacy code. page working on, need substitute fragment divs constructed on back-end -- or else need replace entire page altogether. idea there dynamically controlled flow needs satisfied before can forward legacy product. substituting fragments works fine, seen in below my_body_content swap. trouble comes when i'm trying render not fragment, whole page, in "body" swap. @ point page goes blank. i want similar errors returned server. want nice rest 404 error messages displayed on screen, legacy-product 404s show in legacy-product 404 page. yes, requirements project weird. that's not problem can fix. here's jquery invocation, names changed protect guilty: $.ajax({ url: "places/things", type: "post", data: json.stringify(somebadassobject), datatype: "text", accepts: "text/html", contenttype: "application/json; charset=...
Read more