database - SQL statement ignore when attempted to open cursor -


i have error, "sql statement ignored", when make spec , body of package database in pl/sql.

i wrote code :

procedure get_all_link_recent_result     ( pi_userid        in  tlms_cm_result.userid%type,       pi_email         in  tlms_cm_result.email%type,       pi_testid        in  tlms_cm_result.testid%type,       po_ret_code      out varchar2,       po_ret_message   out varchar2,       po_ref_cursor    out type_cm_result_refcur     )     l_userid           tlms_cm_result.userid%type;     l_testid           tlms_cm_result.testid%type;     begin       l_userid   :=    pi_userid || 0;       l_testid   :=    pi_testid || 0;     open po_ref_cursor      select *       tlms_cm_result       userid l_userid ,       testid l_testid ,       email = pi_email      order       userid;    po_ret_code := c_err_msg_other;   exception     when others       po_ret_code := c_err_msg_other;       po_ret_message := sqlerrm;   end get_all_link_recent_result;

the specific line "pl/sql : sql statement ignore" error line 

open po_ref_cursor

so, statements after that, starting for select * from cause error.

open cursor independent complete statement. is, should ends semi colon. in case semi colon missing.

i'm not sure trying achieve code, cannot test it. not clear me why opening cursor without explicitly closing it. thing seem trying open implicitly cursor for loop. not way it.

for example, rewrite part of code follows:: 

open po_ref_cursor;  --add semi-colon  in (select *   tlms_cm_result   userid l_userid ,   testid l_testid ,   email = pi_email  order   userid)  loop   po_ret_code := i.c_err_msg_other;  end loop;

assuming c_err_msg_other part of select query.


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more