oracle - Script is failing to pass XMLTYPE argument to PLSQL procedure -


i have script supposed open xml file , read contents , process it. plsql procedure test_load.bob_load has been created successfully.

test_load.bob_load looks this:

procedure bob_load(p_uuid in varchar2,       xml_in in  xmltype,       msg_status out varchar2,       xml_out out xmltype);  end  bob_load; /

the script below calls procedure in final line , seems cause of error. assuming not recognising variable x xmltype.

declare     xml_file utl_file.file_type;     chars_read integer;     xml_clob clob;     xamount integer :=32767;     char_buffer varchar2(32767);     x xmltype; begin xml_file := utl_file.fopen('/export/hm/testpit/bob', 'test.xml', 'r', xamount);    dbms_lob.createtemporary(xml_clob, true);  loop  begin  utl_file.get_line(xml_file, char_buffer);     chars_read :=length(char_buffer);    dbms_lob.writeappend(xml_clob, chars_read, char_buffer);    dbms_lob.writeappend(xml_clob, 1, chr(10));    exception    when no_data_found    exit;    end;    end loop;   utl_file.fclose(xml_file);   x := xmltype.createxml(xml_clob);   test_load.bob_load('9718fa05-9995-4f17-jk1k-763113b8f4a4', x );  end;  /

however when run script above ora-06550, pls:00306 error saying:

ora-06550: line 39, column 3: pls-00306: wrong number or types of arguments in call 'bob_load' ora-06550: line 39, column 3: pl/sql: statement ignored

your procedure has 4 parameters. call 2. need call out parameters well.

much easier way read file's contents clob:

function read_clob_from_file(p_directory    varchar2                                ,p_filename varchar2) return clob        l_amt        number := dbms_lob.lobmaxsize;       l_dst_loc    clob;       l_dst_offset number := 1;       l_lang_ctx   number := dbms_lob.default_lang_ctx;       l_src_loc    bfile;       l_src_offset number := 1;       l_warning    number;    begin        l_src_loc := bfilename(p_directory, p_filename);       dbms_lob.createtemporary(l_dst_loc, true);       dbms_lob.fileopen(l_src_loc, dbms_lob.file_readonly);       dbms_lob.loadclobfromfile(l_dst_loc                                ,l_src_loc                                ,l_amt                                ,l_dst_offset                                ,l_src_offset                                ,dbms_lob.default_csid                                ,l_lang_ctx                                ,l_warning);       dbms_lob.fileclose(l_src_loc);       return l_dst_loc;    end;

-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more