Lalitha Vydyula

Ranch Hand
+ Follow
since Jul 20, 2005
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Lalitha Vydyula

Remember, you are not being tested on your HTML knowledge.
Hi Tiffiny,
First of all you forgot to include <servlet-mapping>. Once I included <servlet-mapping>, I called your DateFormatServlet and it working fine for me. I'm using tomcat 5.0.28. There's nothing wrong with your code.
[ February 09, 2007: Message edited by: Lalitha Vydyula ]
Hi all,

trying select max(approval_level).. gives java.sql.SQLException: Invalid column name


I have a query like this
select max(approval_level) as maxlevel from fam_quote_header_approval , fam_quote_line_approval where fam_quote_header_approval.header_approval_id = fam_quote_line_approval.header_approval_id and quote_number = 5443 and status = 'Approved'

when I execute the query from SQL prompt its executing fine. but when I execute it from the jdbc it erroring out

try
{
approvedLvlConn = (OracleConnection)getConnection();
approvedOpstmt = (OraclePreparedStatement)
approvedLvlConn.prepareStatement(approvedLevelStr.toString());
approvedSet = approvedOpstmt.executeQuery();
if(approvedSet.next())
maxLevel = approvedSet.getInt(approvedSet.getInt("maxlevel"));
}

Can anyone help. Thanks.
Hi All,
I want to create a table row dynamically by clicking an add row button.
somthing like this,




But whenever I call the javascript its giving me an error saying
"Unexpected call tp method or property access"

How do I resolve this?
Hi All,
I have a jsp in which I have a hyperlink which takes me to another jsp page. I also have a select element with options 'Y' and 'N'. When I select 'Y' from the options I need to enable the hyperlink to navigate to the other page. When I select 'N' from options I need to disable the hyperlink. How do I do this? Thanks

-Lalitha
12 years ago
JSP
Thanks stu derby. But what I was asking was, how do I call procedure with user-defined IN & OUT parameters. Below is the package spec which might help you uderstand my question more clearly.
----------------------
CREATE OR REPLACE PACKAGE FAM_AR_SUMMARY_PKG IS

TYPE ar_summ_rec_type IS RECORD (
CUST_NAMEhz_parties.party_name%TYPE,
CUST_ACCT_NOhz_cust_accounts_all.ACCOUNT_NUMBER%TYPE,
CUST_ACCT_BALNUMBER,
CUST_PAST_DUE_BALNUMBER,
CUST_UNAPP_REC_BALNUMBER,
CONTRACT_NOokc_k_headers_b.CONTRACT_NUMBER%TYPE,
ANN_DATEokc_k_headers_b.END_DATE%TYPE,
TOT_CONTRACT_VALUEokc_k_headers_b.ESTIMATED_AMOUNT%TYPE,
PAST_DUE_AMTNUMBER,
DAYS_PAST_DUENUMBER,
INV_PAST_DUENUMBER,
DEP_INV_BALNUMBER,
AMT_CREDITEDNUMBER);

TYPE ar_summ_tbl_type IS TABLE OF ar_summ_rec_type
INDEX BY BINARY_INTEGER;


PROCEDURE FAM_GET_AR_SUMMARY(p_cust_name IN hz_parties.party_name%TYPE,
p_chr_id IN okc_k_headers_b.ID%TYPE,
x_ar_summ_tbl OUT NOCOPY ar_summ_tbl_type,
x_excp_messageOUT VARCHAR2);

END FAM_AR_SUMMARY_PKG;

Please help me. Its an urgent requirement.
Hi all,
I have procedure in a package which I need to call from the JDBC. My problem is, that procedure take user-defined data types as IN parameters & gives user-defined OUT paramters. How do I call a procedure like this. Do I need to write the wrapper class. If so from where do I start, I mean I don't have any idea about writing wrapper classes. Its an urgent requirement. Help me please.

The procedure is like this..........

PROCEDURE AR_SUMMARY(p_cust_name IN hz_parties.party_name%TYPE,
p_chr_id IN okc_k_headers_b.ID%TYPE,
x_ar_summ_tbl OUT NOCOPY ar_summ_tbl_type,
x_excp_messageOUT VARCHAR2);
Hi All,
I'm getting the below error when I'm trying to use the setDate() method of the OracleCallableStatement.

java.lang.AbstractMethodError: void oracle.jdbc.OracleCallableStatement.setDate(java.lang.String, java.sql.Date)
at mypackage.ARSummaryUtil.getAmountToBeCredited(ARSummaryUtil.java:119)
at _ARSummary._jspService(ARSummary.jsp:16)
[SRC:/ARSummary.jsp]
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
at java.lang.Thread.run(Thread.java:534)

Here is the code snippet
------------------------------------
try
{
connection = getConnection();
stmt = connection.createStatement();
java.sql.Date date = new java.sql.Date(new java.util.Date().getTime());
result = stmt.executeQuery("select id from okc_k_headers_b where
contract_number='9999'"); // Hardcoded contract_number value
while(result.next())
{
p_id = result.getInt(1);
}
ocstmt = (OracleCallableStatement)connection.prepareCall("begin OKS_BILL_REC_PUB.pre_terminate_amount(?,?,?,?,?,?,?); end;");
ocstmt.setNUMBER(1, null); // IN Paramater1
ocstmt.setInt(2, p_id); //IN Paramater2
ocstmt.setDate("p_terminate_date", new java.sql.Date(sysDate.getTime()));
ocstmt.setInt(4,2); // IN Paramater4
ocstmt.registerOutParameter(5, Types.NUMERIC); // OUT Parameter1
ocstmt.registerOutParameter(6, Types.NUMERIC); // OUT Parameter2
ocstmt.registerOutParameter(6, Types.VARCHAR); // OUT Parameter3
ocstmt.execute();
X_Amount = ocstmt.getFloat(5);
X_manual_credit = ocstmt.getFloat(6);
X_return_status = ocstmt.getString(7);
}

Is it a driver problem.
I'm using JDeveloper 9.0.5.2
In the above class I'm trying to connect to a remote database(version 9.2.0.6.0)
I have 10gR2 installed on my machine.
Can anyone help. Thanks in advance
Hi,
I need to access a remote DB instance from EclipseSDK. Do I need to install any plugins. Could any one help with this. Thanks.


-lalitha