หน้านี้ยังไม่พร้อมใช้งานในภาษาท้องถิ่นของคุณ เรากำลังพยายามอย่างหนักเพื่อเพิ่มเวอร์ชันภาษาอื่น ๆ เพิ่มเติม ขอบคุณสำหรับการสนับสนุนเสมอมา

Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Situation Awareness
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
Software Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive

Checking Debugging Information

Updated on 2022-08-16 GMT+08:00

When you use Data Studio, you can examine debugging information through several debugging panes. This section describes how to check the debugging information:

Operating on Variables

The Variables pane is used to monitor information or evaluate values. The Variables pane can be opened from the minimized window to evaluate or modify variables or parameters in a PL/SQL procedure. As you step through the code, the values of some local variables may be changed.

NOTE:

Press Alt+K to copy the content of the Variables pane.

You can double-click the corresponding line of the variable and manually change its value during runtime.

Click the Variable, Datatype, or Value column in the Variables pane to sort the values. For example, to change the value of the percentage variable from 5 to 15, double-click the corresponding line in the Variable pane. The Set Variable Value dialog box will be displayed, which prompts you to enter the variable value. Input the variable value and click OK.

To set NULL as a variable value, enter NULL or null in the Value column.

If a variable is read-only, will be displayed next to it.

Read-only variables cannot be updated. A variable declared as a constant will not be shown as read-only in the Variables pane. However, an error will be reported when this variable is updated.

NOTE:
  • If 'NULL' or NULL is entered in the Variables pane, the parameter value will be displayed as NULL. This rule also applies to character datatypes.
  • If the value is set to a variable using Data Studio, the value of the variable is the same as the value returned by the statement SELECT EXPRESSION executed using gsql.

Setting/Displaying Variables

Description

Setting a variable to NULL

  1. Double-click a variable value in the Variables pane.

    A dialog box is displayed.

  2. Left the parameter blank.

Setting a string value

Some examples are as follows:

  • To set the value to abc, enter abc.
  • To set the value to Master's Degree, enter Master''s Degree.
  • To set the value as text (NULL), set it to NULL in the Variables pane.

Setting a BOOLEAN value

Enclose the BOOLEAN value t or f within single quotation marks ('). For example, to set t to a BOOLEAN variable, enter 't' in the Value column.

Displaying a variable value

If the variable value is NULL, it will be displayed as NULL.

If the variable value is NULL, it will be displayed as empty.

If the variable value is a string, for example, abc, it will be displayed as abc.

Viewing Results

The Result tab displays the result of the PL/SQL debugging session, with the corresponding procedure name at the top of the tab. The Result tab is automatically displayed only when the result of executing a PL/SQL program exists.

You can click in the Result tab to copy the content of the tab. For details, see Using SQL Terminals.

NOTE:
  • The tool tip in the Result tab displays a maximum of 10 lines, each of which contains up to 80 characters.
  • If the result of an executed query is NULL, it will be displayed as <NULL>.
  • Tab characters (ASCII 009) in table data will not be displayed in the Result, View Table Data, or Properties pane. Tab characters will be included correctly in the copied or exported data, and displayed correctly in the tool tip.

เราใช้คุกกี้เพื่อปรับปรุงไซต์และประสบการณ์การใช้ของคุณ การเรียกดูเว็บไซต์ของเราต่อแสดงว่าคุณยอมรับนโยบายคุกกี้ของเรา เรียนรู้เพิ่มเติม

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback