plsql - How to add values to a VARRAY using a loop -


i have varray , want add elements varray using loop. have tried far.

declare type code_array_  varray(26) of varchar2(6); codes_ code_array_;  begin in 1..26 loop         codes_(i) := dbms_random.string('u',6);   end loop; end;

above code gives me error

"ora-06531: reference uninitialized collection"

as error message says, need initialise collection variable:

... begin   codes_ := code_array_();   ...

but need size it, either single extension each time around loop:

  in 1..26 loop         codes_.extend;     ...

or one-off extension before start:

... begin   codes_ := code_array_();   ...   codes_.extend(26);   in 1..26 loop         ...

you use post-extend size control loop, save hard-coding 26 again:

declare   type code_array_ varray(26) of varchar2(6);   codes_ code_array_; begin   codes_ := code_array_();   codes_.extend(26);   in 1..codes_.count loop         codes_(i) := dbms_random.string('u',6);   end loop; end; /  pl/sql procedure completed.

read more collections.


-

Comments

Post a Comment

Popular posts from this blog

delphi - Disable and change color of node in Treeview -

Image
i looking way of disabling proper nodes . let's have created simple treeview structure below: parent 1 (disable) parent 2 child 1 child 2 (disable) so far have found workaround how that, still doesn't work @ all. use onchanging event handler: procedure tform1.treeviewchanging(sender: tobject; node: ttreenode; var allowchange: boolean); begin if (node.text = 'parent 1') or (node.text = 'child 1') allowchange := false; end; it works, because can't click on node, issue after 'disabling' node way, color of parent 1 , child 1 nodes same other. way change color of nodes (grey)? or maybe know way disabling nodes in ttreeview component? to disable node, set enabled property false . disabled item displayed in gray color. to change normal color of nodes text, change ttreeview.font.color . to change color of disabled nodes text, use oncustomdrawitem event: procedure tform2.treeview1customdrawitem(sender: tcu...
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

node.js - display array of json objects using handlebar in nodejs & express -

i'm new node , trying retrieve data mongodb , display client.i'm using handlebars purpose.i'm retrieving data mongo collection it's array of json objects not display in html. here code snippets : retrieving mongodb: usrrouter.route('/profile/projects') .get(function(req,res){ project.find({pusername:usern},function (err,projects) { if(err){console.log(err); } else{ res.render('projects',{"project":projects}) } }); }); it's results: take on screenshoot html code: <table class="table table-striped"> <thead> <tr> <th>project name</th> <th>project type</th> <th>project description</th> <th>actions</th> ...
Read more