Category Archives: How to Fix

Oracle stored procedure error > ora-24344: the reason for success with compilation error, execute immediate to execute dynamic SQL

Oracle stored procedures are as follows:

create or replace procedure pro_demo
is
begin
   select * from k_cicpa;
end

Error message:
> ORA-24344: success with compilation error
In SQL, the stored procedure exEC displays the query results normally, as shown below.

--drop PROCEDURE pro_demo
create  procedure pro_demo
as
begin
   select * from k_cicpa;
end

 exec pro_demo;


This is the first time I have been exposed to Oracle stored procedures
Reason for error:
Oracle stored procedures cannot be written in such a way as to write simple SELECT… The from… This is different from SQL Server

--Either write
select field into variable from student;
--either written as
execute immediate 'select * from student;'
--either store with a cursor

process is in the form of selet col into v_col from tb
 
--Change it to look like this.

 create or replace procedure p1
 as
  v_sql varchar2(4000);
 begin
   v_sql:='select * from xs';
   execute immediate v_sql;
 end;

Execute IMMEDIATE: Used in a stored procedure. Dynamic execution of SQL statements, such as using local dynamic SQL to execute DDL statements dynamically based on table names entered by the user and parameters such as field names, field types, etc.

create or replace procedure proc_test  
(  
table_name in varchar2, 
field1 in varchar2,  
datatype1 in varchar2, 
field2 in varchar2, 
datatype2 in varchar2 
) as  
str_sql varchar2(500);  
begin  
str_sql:='create table '||table_name||'('||field1||' '||datatype1||','||field2||' '||datatype2||')';  
execute immediate str_sql;   
exception  
when others then  
null;  
end ;

 

Expected unqualified ID before string constant

The answer is: My code is missing a “;”
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
site:

back to the error of the line, found no problem.

error file: ptlogin2_api.h (line 22) : With the unqualified id before string constant

, in the middle of my CPP code (definitely not in the header file), a function XXX from the file ptlogin2_api.h,

#ifdef cplusplus
extern “C” {====== > Which line
#endif

turns out to be wrong?

I’m contains ptlogin2_api. H a recent include file
# include “dev_db_def. H” = = = = = = = = = = = = = = = = = = = “inside out of the question! Enumeration value definition ends with “; “missing. . Ptlogin_app_id.
# include “h”
# include “panel_auth. H”

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
there are multiple solutions can be found that the problem
1) add new code removed entirely, including the header files, to ensure that your code can be compiled through.
2) since there is no problem with the error, there is a problem near the code, or there is a problem with another file nearby. It is often the case that a file ends up missing the “;” , error in another file.
3) vi dev_insert.o is a versatile way to expand the code and see the state of the file when the compiler finally compiles the code. But it’s also the most complicated.

my dev_insert.o expand as follows:

45053 # 42 “.. H “
45054 enum _errorcode55 {
45056 DR_ERR_OK = 0,
45057 dr_err_validity = 1000,
45058 DR_ERR_LOGIN_STATE,
45059 DR_ERR_INSERT_DEV,
45060 DR_ERR_SELECT_DEV,
45061 DR_ERR_UPDATE_DEV,
45062 DR_ERR_ACTION_TYPE,
45063
45064}
45065 # 15 “dev_insert.cpp” 2
45066 # 1 “/data/home/nemo/code/isd_qzoneappbase_proj/base_class/base_lib/include/ptlogin_app_id.h” 1
45067 # 16 “dev_insert.cpp” 2
45068 # 1 “/data/home/ code/isd_qzoneappbase_proj/outerlib/panel_auth/include/panel_auth. H “1
45069
45070
45071
45072 # 1
45072 # 1 “/data/home/ code/isd_qzoneappbase_proj/base_class/extern_libs/tdev/include/toiw_all.h” 1
45073 # 5 “/data/home/ code/isd_qzoneappbase_proj/outerlib/panel_auth/include/panel_auth. H” 2
45074 # 1 “/data/home/nemo/code/isd_qzoneappbase_proj/base_class/extern_libs/tbase/include/tbase_all.h” 1
45075 # 6 “/data/home/ code/isd_qzoneappbase_proj/outerlib/panel_auth/include/panel_auth. H “2
45076 # 1 “/data/home/ code/isd_qzoneappbase_proj/outerlib/panel_auth/include/ptlogin2_api.h” 1
45077 # 25 “/ data/home/nemo/code/isd_qzoneappbase_proj/outerlib/panel_auth/include/ptlogin2_api. H”
45078 extern “C” {45079

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
For detailed debugging procedures, you can refer to a document in the mailbox and search for the keyword debugging using GCC.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
the GCC common error of the error, less often because;

expected unqualified-id before ****
generally occurs with the following prompt information as well as the unqualified ‘; ‘, and look up from the error to see if there is a semicolon missing at the end of the header file and at the end of the enumeration definition included above.

error: multiple types in one declaration
>
error: multiple types in one declaration
> In the second class, the last error.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
type redefine link failure, if can’t find the cause of the code, may be written makefile have problems
the same. The two o file link, in this mistake. Depressed.
Make your own makefiles under GCC. Be very careful.

ERROR StatusLogger No log4j2 configuration file found.

The tool is Intellij Idea
The

    in SRC – & gt; So I’m going to go under main and I’m going to go under resources and I’m going to go under resources and I’m going to go under log4j2.xml

The file contents of log4j2.xml are as follows

<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
    <Appenders>
        <Console name="STDOUT" target="SYSTEM_OUT">
            <PatternLayout pattern="%d %-5p [%t] %C{2} (%F:%L) - %m%n"/>
        </Console>
    </Appenders>
    <Loggers>
        <Logger name="com.opensymphony.xwork2" level="info"/>
        <Logger name="org.apache.struts2" level="info"/>
        <Logger name="org.demo.rest" level="debug"/>
        <Root level="warn">
            <AppenderRef ref="STDOUT"/>
        </Root>
    </Loggers>
</Configuration>


And then it’s ok

#How to handle the installation rollback and 1205 connection error of pulse secure ා

To use the school server to run data before deciding to VPN client xiaonei.
I didn’t expect all kinds of problems to happen…
I am a Win8 system. I installed Pulse Secure and have been rolling back. I tried various methods on the Internet, such as changing MaxFilternum, uninstalling anti-virus software and adding administrator privileges, but all failed.
Check the local services – Enable Device Install Service and Device Setup Manager, and the installation is successful again!

processing on 1205 error unable to set virtual adapter:
This is generally a problem of installation. My error may be caused by the mismatch between the file pulse Client setup.exe downloaded when I used the web VPN… In short, uninstall Pulse Secure and then reinstall it. Be sure to uninstall it clean!! Can not uninstall or uninstall the process error must have a file residue, check your task manager to see what relevant procedures are running, and then right-click to close (I am through this method to find a client setup program) find the root directory uninstall clean, and then reinstall!

No matching distribution found for tensorflow

My Python version is installed with Anaconda version 3.7, while the 3.7 Version of Python is not installed with PIP Install TensorFlow – GPU could not install TensorFlow, possibly because of incompatibility?
Solutions:
Uninstall Anaconda, install a 3.6 or lower Version of Anaconda, and then PIP Install Tensorflow-GPU.
It was updated December 17, 2018
I found this error today not because of the Anaconda version, but because I downloaded a 32-bit Version of Anaconda, but my Linux system is 64-bit…
I’m not in a good mood today, um…

Python3 reports an error [errno 5] input / output error. Print is used when there is no stdout

Process description
Shortly after, I wrote a project with Tornado that was supposed to be deployed on Nginx, but for some reason the company didn’t use Nginx and started it directly from the command line
When I boot from the command line, it is normally accessible

python start.py &

However, when I close the remote SSH connection, the program is out of order, nothing happens, but the process is sitting in the process pool waiting for the CPU to call. By try catch the exception [Errno 5] Input/output error
After checking, the problem was found, because I had print statement in the program. When I quit the remote SSH, it was equivalent to closing its shell. Without shell process print, there was no place to output characters and could not “write” to the screen, so I would report a I/O error
The solution

    does not use the command line to start, put the program into crontab to start regularly or delete the program where there are print statements in the program, use nohup to run the command permanently, it has nothing to do with the user terminal, disconnection of SSH will not affect the program to run

 

Error c2137 of C language: empty character constant (Fixed)

Write a function that removes all whitespace from a string
Error analysis:
This is because when the character constant is a space character, you cannot enter only two single quotes, you must also enter a space between the two single quotes; Otherwise, an error will be reported when compiling, prompting null characters, as shown in the figure:

After consulting materials, it is not allowed to put nothing between two single quotation marks. After modification, it is shown in the following figure:

Code:

#include <stdio.h>
#include <ctype.h>
#include <conio.h>
#include <stdlib.h>
void fun (char *str)
{
    int i=0;
    char *p=str;
    while(*p){
        if(*p!=' '){     //Del Space key
            str[i++]=*p;
        }
        p++;
    }
    str[i]='\0';        //add Terminator
}
main()
{
  char str[81];
  char Msg[]="Input a string:";
  int n;
  FILE *out;
  printf(Msg);
  gets(str);
  puts(str);
  fun(str); 
  printf("*** str: %s\n",str); 
  /******************************/
  out=fopen("out.dat","w");
  fun(Msg);
  fprintf(out,"%s",Msg);
  fclose(out);
  /******************************/
}

 

Error: listen eadrinuse: address already in use

Listen EADDRINUSE: Address already in use Error: Listen EADDRINUSE: Address already in use Error: listen EADDRINUSE: Address already in use Error.
solution (I use MAC system) : type sudo lsof – I: port number in the console, view the pid of the occupied process, and then type sudo kill -9 pid to kill the process.

error C2061: syntax error : identifier ‘BinryTreeNode’

1> D :\ My documentation \ Visual Studio 2005\ Tree \ Tree \tree\tree.h(23) : Error C2061: Syntax Error: Identifier ‘BinryTreeNode’

1> D :\ Visual Studio 2005\ Projects \ Tree \ Tree \ Tree.h (77) : See reference to class Template Instantiation
‘BinaryTree< T> ‘ being compiled

At the error indicated in the first line ‘BinaryTree< T> ‘Writing error