oracle11g - converting to Oracle sp from SQL Server 2 lines "not recognized" -


i using oracle sql developer scratch editor tool. there couple of small errors, not sure how fix.

--sqldev:following line not recognized while @i <= @pat_cnt  --sqldev:following line not recognized begin  select pat_number ,        patient_id ,        mrn ,        last_name ,        first_name ,        unit_code ,        nursing_unit ,        sdt ,        edt ,        shift_code ,        start_time ,        end_time     v_pat_number,        v_patient_id,        v_mrn,        v_last_name,        v_first_name,        v_unit_code,        v_nursing_unit,        v_sdt,        v_edt,        v_shift_code,        v_start_time,        v_end_time   tt_v_pats   pkey = v_i;   begin    v_l_cur_date := trunc_date(v_p_start_date) ; end;  --sqldev:following line not recognized while @l_cur_date <= optc.trunc_date(@p_end_date)  --sqldev:following line not recognized begin

it's not obvious me attempting here...

in pl/sql, variables declared in declare section of anonymous pl/sql block or in is/ as section of named pl/sql block (a stored procedure or stored function). in pl/sql, begin needs paired end-- see bunch of begin statements in code no associated end. , in pl/sql, don't use @ refer variables.

something syntactically valid, it's not obvious want, however.

declare   v_pat_number     tt_v_pats.pat_number%type;   v_patient_id     tt_v_pats.patient_id%type;   v_mrn            tt_v_pats.mrn%type;   v_last_name      tt_v_pats.last_name%type;   v_first_name     tt_v_pats.first_name%type;   v_unit_code      tt_v_pats.unit_code%type;   v_nursing_unit   tt_v_pats.nursing_unit%type;   v_sdt            tt_v_pats.sdt%type;   v_edt            tt_v_pats.edt%type;   v_shift_code     tt_v_pats.shift_code%type;   v_start_time     tt_v_pats.start_time%type;   v_end_time       tt_v_pats.end_time%type;   v_pat_cnt        integer := 100; begin                    in 1 .. v_pat_cnt   loop     select pat_number ,               patient_id ,               mrn ,                      last_name ,                first_name ,               unit_code ,                nursing_unit ,             sdt ,                      edt ,                      shift_code ,               start_time ,               end_time                                     v_pat_number,              v_patient_id,              v_mrn,                     v_last_name,               v_first_name,              v_unit_code,               v_nursing_unit,            v_sdt,                     v_edt,                     v_shift_code,              v_start_time,              v_end_time            tt_v_pats            pkey = i;        <<do local variables>>   end loop; end;

of course, can use record types simplify code bit

declare   v_pats_rec       tt_v_pats%rowype;   v_pat_cnt        integer := 100; begin                    in 1 .. v_pat_cnt   loop     select *                                    v_pats_rec          tt_v_pats            pkey = i;        <<do record>>   end loop; end;

Comments

Post a Comment

Popular posts from this blog

jquery - Invalid Assignment Left-Hand Side -

i trying assign class tag via jquery, resulting in error through firebug says "invalid assignment left-hand side" on fourth line below. <cfoutput> $('.pngfix a').each(function(index) { var hreflink = $(this).attr("href"); if (hreflink.tolowercase() = '../audio.cfm') { $(this).addclass('audioimg'); } }); </cfoutput> looking around online, looks syntax problem, don't seem see it... any tips? thanks if (hreflink.tolowercase() = '../audio.cfm') that attempts assign value, rather check equality. change = operator == .
Read more

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more