Comments by aghori - CodeProject

aghori 2-Sep-13 4:15am View

k actually when u post a question, you need to enter the tag field,in the tag field there is a hardware option too.That made me think one can also post hardware issues.How ever Mr OriginalGriff provided me a solution.Looks like that is the only option I can implement.

aghori 31-Aug-13 1:29am View

My sincere apologies to you for this act of disrespect.I did not know "all caps" is considered as shouting.I am very new to this site.How can I shout or show disrespect to highly qualified people like you who are always ready to guide me.Moreover I mentioned "Hardware" in tag field while posting this query.How come did it reach software professionals instead of hardware professionals.Can you please tell me some other such ethics so that due to lack of knowledge i don't commit such mistakes further.

aghori 31-Aug-13 1:28am View

My sincere apologies to you for this act of disrespect.I did not know "all caps" is considered as shouting.I am very new to this site.How can I shout or show disrespect to highly qualified people like you who are always ready to guide me.Moreover I mentioned "Hardware" in tag field while posting this query.How come did it reach software professionals instead of hardware professionals.Can you please tell me some other such ethics so that due to lack of knowledge i don't commit such mistakes further.

aghori 31-Aug-13 1:28am View

My sincere apologies to you for this act of disrespect.I did not know "all caps" is considered as shouting.I am very new to this site.How can I shout or show disrespect to highly qualified people like you who are always ready to guide me.Moreover I mentioned "Hardware" in tag field while posting this query.How come did it reach software professionals instead of hardware professionals.Can you please tell me some other such ethics so that due to lack of knowledge i don't commit such mistakes further.

aghori 31-Aug-13 1:28am View

My sincere apologies to you for this act of disrespect.I did not know "all caps" is considered as shouting.I am very new to this site.How can I shout or show disrespect to highly qualified people like you who are always ready to guide me.Moreover I mentioned "Hardware" in tag field while posting this query.How come did it reach software professionals instead of hardware professionals.Can you please tell me some other such ethics so that due to lack of knowledge i don't commit such mistakes further.

aghori 2-Aug-13 3:48am View

thank you Frerik Bornander

aghori 2-Aug-13 1:05am View

shinde sir u online nw

aghori 31-Jul-13 9:18am View

i am sorry for not telling the error.actually it is raining heavily at my place due to which dere are power cuts.will the following help u get an idea or u need soethin more desciptive.
Exception in thread "main" java.sql.SQLException: ORA-06550: line 1, column 86:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent="" (**)=""> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ between || indicator
multiset member SUBMULTISET_
The symbol ")" was substituted for ";" to continue.

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:211)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1159)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4244)
at Ptech.Financial_Year_Procedure.Call_Financial_Year_Procedure(Financial_Year_Procedure.java:33)
at Ptech.Financial_Year_Procedure.main(Financial_Year_Procedure.java:68)
Java Result: 1

aghori 31-Jul-13 8:42am View

CREATE OR REPLACE PROCEDURE PR_INSERT_FINANCIAL_YEAR(P_COMPANY_ID IN NUMBER,
P_BRANCH_ID IN NUMBER,
P_F_YEAR IN NUMBER,
P_FROM_DATE IN DATE,
P_TO_DATE IN DATE,
P_STATUS IN CHAR,
P_ENTERED_BY NUMBER,
P_ENTERED_DATE IN DATE,
p_Updated_By NUMBER,
p_Update_Date In Date,
p_Ip_Address In Varchar2,
p_Mac_Address In Varchar2,
P_Year_close in char,
p_Flag In Char,
p_Errbuff Out Varchar2,
p_Errcode Out Varchar2)

IS

BEGIN
IF p_Flag = 'I' THEN

INSERT INTO FINANCIAL_YEAR
(COMPANY_ID,
BRANCH_ID,
F_YEAR,
FROM_DATE,
TO_DATE,
STATUS,
entered_by,
ENTERED_DATE,
Updated_By,
Update_Date,
Ip_Address,
Mac_Address,
year_close)
VALUES
(P_COMPANY_ID,
P_BRANCH_ID,
P_F_YEAR,
P_FROM_DATE,
P_TO_DATE,
P_STATUS,
P_ENTERED_BY,
P_ENTERED_DATE,
p_Updated_By,
p_Update_Date,
p_Ip_Address,
p_Mac_Address,
p_year_close);

p_Errbuff := 'Transaction Saved succssfully..';
p_Errcode := '001';
END IF;
commit;
END;

aghori 31-Jul-13 8:40am View

actually i am a fresher so my questions may sound illogical.kinly forgive

aghori 31-Jul-13 8:38am View

i will send you the code of my procedure that i have created so that u come to know my column names.is.it ok?

Comments by aghori (Top 11 by date)