User defined table types in Oracle -


first of working mssql. have stored procedure in mssql, need use in oracle , since absolutely new oracle have no idea @ how correct.

i needed use user defined table types in ms sql stored procedure because using "logical" tables in stored procedure, need pass them dynamic sql statement within procedure (using column names of "physical" tables variables/parameters).

i've started add oracle function in package made before function. looks like

type resultrec record (    [result columns]  );  type resulttable table of resultrec;  function myfunctionname([a lot parameters]) return resulttable pipelined;

i described layout of tables (the user defined table types in mssql), want use within function in package header. far good, don't know have declare table variables or user defined table types. tried put them in package header, if trying use these tables in package body, describing function, oracle tells met, table or view not exist. tried describe tables within package body or in block of function, looks that:

function myfunctionname (    [myparameters] ) return resulttable pipelined rec resultrec;  type tablevariablea table of tablereca; type tablevariableb table of tablerecb;  begin    insert tablevariablea   select columna, columnb physicaltable where[...];    [a lot more do...] end;

but in case oracle tells me, doesn't know table or view. tried few more things, @ end wasn't able tell oracle table should use... appreciate every hint, helps me understand how oracle works in case. lot!

you can't insert collection (e.g. pl/sql table). can use bulk collect syntax populate collection:

select columna, columnb bulk collect tablevariablea physicaltable [...];

however, might want check appropriate approach, since sql server , oracle differ quite bit. can't use pl/sql tables in plain sql (at least prior 12c), inside procedure, might need schema-level type rather pl/sql type, depends next. might not want collection @ all. trying convert t-sql straight pl/sql without understanding differences lead down wrong path - make sure understand actual requirement , find best oracle mechanism that.


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl>
Read more

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

using jqueryui splitter or resizable functions want create layout allows unlimited amount of columns added , columns need resizable. so fiddle: https://jsfiddle.net/f3glh3mw/ but in fiddle html contains out of nested sets instead of inline. limits possibilities above fiddle can have equal widths 2,4,8,16,32 etc columns. in between shows crooked can see in fiddle. when researching came on question: jquery ui , splitter if @ top answer shows structure like: <div class="wrap"> <div class="resizable resizable1"></div> <div class="resizable resizable2"></div> </div> full fiddle: http://jsfiddle.net/8qztj/86/ which structure want javascript hardcoded 2 resizable items. so here question: how modify last fiddle works amount of .resizable divs. or know of plugin can this. thanks helping! so far found plugin: http://www.bacubacu.com/colresizable/ which says , close functionality want. in
Read more

javascript - IE9 error '$'is not defined -

Image
<!--[if lte ie 9]><html class="lte9"><![endif]--><!--[if gt ie 9]><html><![endif]--> <!--[if !ie]><!--> <html> <!--<![endif]--> blah blah <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <script src="{{ asset('js/mypage.js') }}" type="text/javascript"></script> </body> </html> when load page, ie9 brings error '$' not defined . how can solve error? +++ mypage.js $(function(){ //when load page, //ie9 tag not moving. $(window).load(function() { $('div.mask').hide(); }); // when click , willshow show. //for not ie 9 if (!$('html').hasclass('lte9')) { var = $('ul.about > li > span.activebtn');
Read more